Update master and child table

  • Thread starter Thread starter angellijah
  • Start date Start date
A

angellijah

I have two tables - Parent Info and Code Info. The Parent Info table shows
"Parent Code", "date opened", "source", "case #", etc. The Code info shows
"Code", "Product", "Value", etc. that are all related to each particular
Parent code. Each month I import an excel sheet to a table (link tables made
it take too long for users to open the database). I can't figure out how to
run a query to add the new codes without adding an entry for the parent code
for each code, rather than one entry for the parent code and adding the child
codes to link up to the one parent code. I hope this makes sense, because I
really need help!
 
Hi Angel,

Create another column in your monthly import to fill out the
parent ID.

Make a query to append records to the parent table.

Then use an update query on the import table to record the
newly created parent IDs -- hopefully there will be a unique
field (or combination of fields) you can use to link

Then use an append query to add records to the child table

Warm Regards,
Crystal
remote programming and training
http://MSAccessGurus.com

free video tutorials
http://www.YouTube.com/user/LearnAccessByCrystal

Access Basics
http://www.AccessMVP.com/strive4peace
free 100-page book that covers essentials in Access

*
(: have an awesome day :)
*
 
Back
Top