Search or find?

[TimjHebert]

i have a table with the following fields.
Customer
Rig
Vessel0
Vessel0serial
Vessel1
Vessel1serial

How can i do a search for a particular vessel when every customer will have two of them?

Thanks,
Tim

 

[KenHigg]

Normalize.

ken

 

[TimjHebert]

Search or find

what do you mean by normalize?

Thanks,
Tim

 

[KenHigg]

Sorry, It just seems you may need to split the rig data out into a seperate table...

Ken