Microsoft access cant create this relationship and enforce referential integrity

[LOUIX]

HI everybody,


I am having an issue when trying to make a relation between 2 tables. Attached the access table
I want to link table tblCustomer to tblVehicle
The tblCustomer has 1 customer ID whereas the tblVehicle has many customer ID.
Therefore it should be many to one
but i get the below message
"microsoft access cant create this relationship and enforce referential integrity"

Can you please help me why this error message keep pop up


Thanks
Ludovic

[Bob Fitz]

The tblCustomer has 1 customer ID whereas the tblVehicle has many customer ID.
Therefore it should be many to one

Perhaps it should be but as far as I can see you don't have any matching records which is why you get that message.

[Bulzie]

Does every vehicle record have a customerID in the tblCustomer table?

[LOUIX]

ohh man, i see, you are right, there is no matching records, that why i got this error
Thanks very much