Need help!

[TimjHebert]

I have 2 tables Table1 and Table2

Table1
CustomerID-PK
Customer
Contact

Table2
BoatID-PK
CustomerID
SerialNumber

i have the relation setup with CustomerID one to many. i can setup a query and with a combo box on a form select by CustomerID and all works fine. How can i setup to select by Customer?

Thanks in advance!
Tim

 

[dt01pqt]

Make sure your table or query in the row source includes the two columns then change the bound column to 2. It’s a visual thing really.