Referential Integrity

[U810190]

If I create a dynamic query with two tables, will both the tables be updated with any new records added to the query?

i.e.primary key in the parent table is "company," and is linked to the "company" field in the child table.

If I add a new record in the query, will both tables update even though I only pulled the "company" field from the parent table into the query?

[RuralGuy]

Assuming the query is updateable, then I would have to say yes.