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.
kwarden13Asked:
Who is Participating?
 
johanntagleConnect With a Mentor Commented:
I don't use Access, but assuming it follows standard joins, to determine what in table 1 but not in table 2, you need a left outer join:

select t1.ID
from t1 left outer join t2 on t1.ID=t2.ID
where t2.ID is null;

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.