Updating Multiple Tables in a Form

  • Thread starter Thread starter Kelly
  • Start date Start date
K

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
 
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
 
Back
Top