Many-To-One Append Query

[Guest]

I want to append data to two tables with a many-to-one relationship. I've set
up two queries, one to select the data for the "one" side of the
relationship, and one to select the data for the "many" side of the
relationship. How do I go about appending this data to the two tables whilst
linking the two sets of data?

They are linked on an Autonumber field in the "one" side of the relationship
in the second set of tables.

Thanks,

Dave

 

[pietlinden]

Append data to the ONE/parent side first and then to the Many/child
table second.
As long as you don't have autonumbers in the destination tables you
should be fine.

 

[Guest]

That's the problem, I do have autonumbers. I got it to work eventually
though. I just had to be careful with the criteria I used to select each set
of data.

Thanks,

Dave