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

Autonumber field in Excel that behaves the same as Access 0
Excel does not accept text format! 0
Dealing with a Pivot Table (when I don't want to) 0
List all tables, including document structure 0
Adding data to MS Access from csv file 0
Access 2013: Form problem in reading data tables; relationship one-to-one 0
How do I clear a form? 0
Excel - Wich Function should I use? 1

Top