Update master and child table

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!
 
C

Crystal (strive4peace)

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 :)
*
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

parent child link query 1
Lookup formula required 8
Parent Form in Datasheet view displays Child Table 1
Pivot Table - Parent to Child Data 1
Display Child Records in subform 7
Parent/Child dataset select 2
Query showing all records from child table 5
Macro to Refresh child pivot table 4

Top