How can i create a new table with a "Make Table" query without deleting all the relationships every time?
Novice
Windows 7 64bit 
Access 2010 64bit
How can i create a new table with a "Make Table" query without deleting all the relationships every time?
Moderator
Windows 10 Access 2010 32bit
Create the table on the 1 side of the relationship before building/populating the related table(s).
Why do you have to use the make Table query multiple times?
Perhaps you could tell us in plain English -no Access jargon -what you are trying to do. It would help put your question into some context and would help readers in formulating a response.
Make Table Query will not make a table that already exists
Is it necessary to create table relationships BEFORE creating a query?
Posting Permissions
Reply With Quote