OK, I think my problem is in my tables

[tim1234]

Hello, I find myself trying to create a new database after a few years of not working with access. What I want to be able to do is take information from table tblPartInformation, and have it populate text fields on a form that will store the information in a table or query called InspectionInformation. My question is, if I want to be able to pull up part # in a combobox on a form and have additional data from partinformation stored in the InspectionInformation, do I use just two tables, or do I need a query to join them? Thank you for any help. It is greatly appreciated.

 

[neileg]

You need to use a query. You need to avoid duplicating data so you would hold the part number in the inspection table and use a query to retrieve the part information when needed.

 

[tim1234]

Thanks

Thanks, I thought that was what I needed to do, but wanted to know before I spent the time. Thanks for the help.