Good afternoon, folks. I have a main table and four subtables all linked thru the pkey, ECNNumber. I want to append the data in all of the tables for each ECNNumber that is completed, CompleteDate=Date(), to five exact tables in another dbase. My question is basically would I have one large append query or five small append queries? Thank you in advance to anyone rendering any assistance on my problem.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Question about Append Query with Multiple Tables
- Thread starter quest4
- Start date
- Status
Similar threads
- Question