Append Query

[Guest]

I have a table that I imported as a new table. I have fields in this table
that I want to add to 2 different tables. A main table which has a form and a
second table that is used as a subform in the main form. Is it possible to
create an append query and add these fields into both tables at the same
time. If I select both tables in the query window and select the fields I
want added to the tables, will the data be added correctly in both tables
since they are related with the ContactID field?

This might be a bit of a stupid question, but if you don't know, I believe
you should ask. I am using Access 2003.

Thanks in advance for any help.

Best regards,

Dee

 

[Jeff Boyce]

Dee

Is there a "business need" to do this ("into both tables at the same time"),
or is this a "nice to have"...?

A simple (but perhaps not 'elegant') solution is to create two queries: one
that appends to the main table, and one that appends to the related table.
Please note that whether you use one form or ten should probably be
irrelevant to how you store your data. In Access, it all start with the
data.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP