• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 389
  • Last Modified:

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.
0
kwarden13
Asked:
kwarden13
1 Solution
 
johanntagleCommented:
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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now