Evening...are you trying to do the following...
An append query adds a group of records from one or more tables to the end of one or more tables. For example, you might have data on new customers stored in a linked table and need to add this data to another table. You could use an append query. An append query can also do the following:
If so a second question for you...in Table1 you said it has a LookUp list...are you trying to copy the data that is already populated in the records in Table1 or the LookUp list that is used to fill in the field when the user is entering the data? I guess the first place to start is with confirming if you're looking to perform a Query append (described above).
1) Through no fault of yours, your answer did not serve. I had tried an append quiry, and it did not work. Sorry I did not tell you that.
2) While awating your reply, I recieved the correct answer from another source.
3) Please refund my $48.00 deposit.