Updating Multiple Tables in a Form

[Kelly]

Is it possible to update multiple tables in a single form
without using Subforms? I can create a query and update
two tables in a single form but when I add a third
related table it no longer allows me to add new records.
Thanks

 

[Michel Walsh]

Hi,

It is possible, as long as the query is updateable (test it in the query
designer), but it may be unwise, in complex cases, and it is not necessary
recommended to update multiple tables at the "same time" (data referential
integrity, multiple update through a join, etc.).


Hoping it may help,
Vanderghast, Access MVP