spalmateer
Registered User.
- Local time
- Today, 15:43
- Joined
- Dec 5, 2000
- Messages
- 46
Hi,
I have two tables that were related with a one to one relationship. I no longer need all the fields in one of the tables and I want to combine the remaining fields of that table into the first table. I'm trying to use an append query with no luck.
The method I've used is creating a new query with the old table fields that I want in the first table. Then I change the query to append and choose the table I want to append to (first table). Then I select the fields where I want to append the information to and run it. It ends up just adding the records at the end and not updating each record. Please help! Thanks in advance!
Scott
I have two tables that were related with a one to one relationship. I no longer need all the fields in one of the tables and I want to combine the remaining fields of that table into the first table. I'm trying to use an append query with no luck.
The method I've used is creating a new query with the old table fields that I want in the first table. Then I change the query to append and choose the table I want to append to (first table). Then I select the fields where I want to append the information to and run it. It ends up just adding the records at the end and not updating each record. Please help! Thanks in advance!
Scott