Two separate tables in Access I need to match the data using a Pke

C

CarisaJo

I have two separate tables in Access that are both relevent to my Excel
spreadsheet. Using a unique ID, I would like to match records from one table
to another in Access and populate one tables data into the other table. Is
this possible?
Thanks
 
K

Ken Snell MVP

Use a form and subform to do this. Or write VBA code to automatically do
this.
 
J

Jeff Boyce

In a well-normalized relational database, there'd not be a need to add
records from one table to another. Perhaps you could describe further what
having the records moved would allow you to do?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

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

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Update Two Tables Using One Form Contents 0
Store similar types of records all in one table or separate tables? 2
Linking Two Tables 2
Combining two tables with respect to corresponding records' individual data cells 0
Query that will look for duplicate in two tables. 3
Please help - I need to separate data to two tables using one form. 0
VBA - retrieve data on last create named range from previous inserted named range 0

Top