Query based Forms won't update tables!

[Lee Hudson]

I have a form which is based on a select query that brings together 2 related (one to many)tables. When I keyin data to the form it does not update the corresponing table.

Is it possible for a table to be updated in such a way, or do I have to create a form based solely on the table(s) without using a query?

 

[gromit]

Hi Lee - welcome!

There are different types of queries: updatable and non-updatable. Using an aggregate function (SUM, MAX, AVG, etc.) can create a non-updatable query. It may also be a factor of your joins of the tables.

Take a look at the following link and see if that is any help -
http://www.fmsinc.com/tpapers/nonupdat/

- g

 

[Pat Hartman]

It is best to use a main form with a subform if you want to update data in two tables.

Your current problem may be that you selected the join field from the many-side table rather than the join field from the one-side table.