RexesOperator
Registered User.
- Local time
- , 22:22
- Joined
- Jul 15, 2006
- Messages
- 604
I am running an append query to transfer records from one database to another.
Is there any way to append ALL related tables without using a separate query for each table? The problem is there are too many fields for a single query to handle at one time.
Right now the table relationships are:
tblCompanies(17 fields)->tblContacts(26 fields)->tblTransactions(26 fields)->tblSites(51 fields).
I can do this with four separate queries, but I'd like to do it in one step.
Is there any way to append ALL related tables without using a separate query for each table? The problem is there are too many fields for a single query to handle at one time.
Right now the table relationships are:
tblCompanies(17 fields)->tblContacts(26 fields)->tblTransactions(26 fields)->tblSites(51 fields).
I can do this with four separate queries, but I'd like to do it in one step.
