Need Help ! (1 Viewer)

[TimjHebert]

i have 2 tables, table1 and table2.

table1
CustomerID
Customer
Contact

table2
BoatID
CustomerID
Boat
Serial

I made a form to input the data, all works ok. i also made a form to search by customer, this works ok. I i make a form to search by serial or Boat, it does not work. I have a relationship of one to many from table1(CustomerID)PK to CustomerID in table2.

Can anyone tell me what is wrong?

Thanks in advance!
Tim

 

[Len Boorman]

I suspect that you are acyually trying to search by both boat and Serial

whereas you actually need to search by boat OR Serial.

To get an OR condition you need to put the second criteria on the OR line in the query grid. Top lin eis AND condition

Len B