Help with relationships (1 Viewer)

[TimjHebert]

I have 2 tables. tblcontact and tblboat.

tblcontact
CustomerID-PK
Customer
Contact

tblboat
CustomerID-FK
boat
Serial

i have made a form to enter the data, all works ok. I built a form to search by customer and it works fine. I can not find a way to build a form to search by boat name or serial. Can some one please help?

Thanks in advance!
Tim

 

[Pat Hartman]

You are missing a primary key on the boat table.

Create a form based on a query of the boat table. Create a subform based on a query of the contacts table. Make sure the master/child links are properly set. You can use the built in search features for the main form or create your own.

 

[TimjHebert]

Sorry but i do have a PK in tblboats, i forgot to list it. my tables are as follows.

tblcontact
CustomerID-PK
Customer
Contact

tblboat
BoatID-PK
CustomerID-FK
boat
Serial

when i use a form with a combo box to fill the fields by selecting a customer all works fine. Can you please tell me how i can build a form with a combo box to autofill by boat name or serial?

Thanks in advance!
Tim