How to copy query results to linked table
I have a make table query that makes a table . . . naturally.
The problem is I want it to make a linked table (on the back end) that has
relationships. When I choose to do this (by setting the table to "another
database"), it does not let me due to the relationships.
What I want is the data of the query to be copied into the table, deleting
whatever was in the table to begin with. It would also be nice not to carry
the weight of that table on the front end.
Is this the same as running a Delete query and then a Append query?
Doyle
