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