Update and Append Query Help

[crazdandconfusd]

Can anyone explain or point me to a thorough explanation on how to create an update query? I have normalized a table of data into two separate tables linked by another table with ID number fields. This created my starting point, but now as I import an updated table later, I would like to update the split tables with missing/new data and update existing data if different from the imported table.

 

[Galaxiom]

An Insert (AKA Append) query can only add new records.

An Update query can change existing records but can also insert new records if it uses an Outer Join.

Join the existing table and new data table on the key fields and change the join type to the type description that includes something that means "Include all records from the new data".

Right click on the join to make this change.

We would need more detail to advise further.

 

[crazdandconfusd]

I think I've made the update query as stated in the response. The only thing I see happening now is it is repeating entries into the tables. I'm trying to have a unique job with amplifying information for that job in one table and then add all parts ordered with amplifying part information in another table. I've attached an image of my current relationship since I cannot attach a sample of the database due to size upload restrictions.

 

[Galaxiom]

Sorry, I left out part of the required instructions.

Add the key field from the original data table to the query and give it a criteria of:
Is Null