Create Form to add NEW IDs to a 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.

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.
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;

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.