Append Query Using 2 Tables

[burrina]

I need to do a append query but the data is store in 2 tables that I need to append to. My Primary table that the data is coming from does NOT have all the matching fields to the tables being appended to but the data types are the same. Maybe a dumb question but do the tables in the grid have to be linked? My form that displays the data uses 4 tables for it's data source and hence the dilemma. Do I need to do separate append(s) to each Table individually?

[June7]

Could possibly be done if the destination tables have a one-to-one relationship and the pk/fk is not autonumber, however, never seen this tried.

Do two append actions.

[burrina]

Good advice, Thanks