kwarden13
asked on
Create Form to add NEW IDs to a table
Hi
Background Info:
I have one table of orders i append to every week. There is a field called ID which is used to look up the region.
Then I have another table that has 2 fields--- ID and Region.
I then have an update query that links the ID fields in both tables to update the Region field in the 1st table. The region field is manually inputed.
Problem:
There are new IDs every week and I would like to create some sort of query that would compare the 2 tables, find the new ids from the 1st table and add the new IDs to the 2nd table. Then create a form/popup so that the region field can be inputed into the 2nd table.
Background Info:
I have one table of orders i append to every week. There is a field called ID which is used to look up the region.
Then I have another table that has 2 fields--- ID and Region.
I then have an update query that links the ID fields in both tables to update the Region field in the 1st table. The region field is manually inputed.
Problem:
There are new IDs every week and I would like to create some sort of query that would compare the 2 tables, find the new ids from the 1st table and add the new IDs to the 2nd table. Then create a form/popup so that the region field can be inputed into the 2nd table.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.