ACC 2016 - Cannot update data in a query based on two tables

[Mercure67]

Hello,

First of all, sorry for my English …


I have following problems. I would like to build a query based on 2 tables and be able to modify data in a table form.
The 2 tables are linked, ‘one to many’. There is also a selection based on a field ‘Date’. Unfortunately, a ‘manuel’ update (add or change data in a cell) is not possible. I’ve done a lot of research, without success.
Could somebody help ?

Many thanks.

[pbaldy]

See if this helps:

http://allenbrowne.com/ser-61.html

a one to many relationship is usually represented with a form and subform.

[Mercure67]

Hello pbaldy.

Thank you for your answer. I will have to find another way to do the updates I need to do.

[pbaldy]

No problem. Try the subform approach.