By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,728 Members | 1,411 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,728 IT Pros & Developers. It's quick & easy.

Combining several tables within MS Access 2007

P: 1
I have two tables that have, for the most part, different columns. One is a Property Book table that has columns including an auto ID, Serial, NOMIN, Tech ID and Sublin. The other is a Technology Table, including an auto ID, Serial and description amongst others. The Tech ID field in the Property Book Table has the corresponding auto ID from the Technology Table, but not all items from the Property Book Table have a Tech ID. I would like merge the two tables together and join the records that have the same serial, or tech ID (if a serial number is missing). Can anyone help me?
Mar 1 '14 #1
Share this Question
Share on Google+
1 Reply

P: 5
What is the complete field structure for each table? I don't see mention of a TechID in the Technology table.
Mar 2 '14 #2

Post your reply

Sign in to post your reply or Sign up for a free account.