Query - Lookup/Query Repeating data entery

[icemac]

I am creating a database for a hyperthetical car hire company.

I have a field with a lookup/query. The data that this query searchs for is entered into my table/form already. Is there anyway of avoiding repeating this data twice?

Iain

 

[Matt Greatorex]

You could set the table property to not allow duplicates in certain fields or you could perfom a search before saving any changes, to check if the data is already in the table?

 

[icemac]

i dont think i am explaining myself very well so here goes again

i have a car type filed and a numberplate field. When i click on the number plate field a search box appears. Here you type in the name of the type of car "sports car" (for example) and generates me a list of all the numberplates that correspond to a sports car.
However the car type "sports car" has already been entered into the car type field.

Is there anyway to prevent having to enter this data in twice?