Relationship

[LOUIX]

Hello All

I have 2tables tblInput and tblVehicles attached
The fieldtxtReg in the tblInput table should be linked with the txtReg in thetblVehicles table with EnforceReferential Integrity
But I got the below error
No Unique Index found for the referenced field of the primary table

Would you please help me how to link it via the relationship


Thanking you for your help
Ludovic

[orange]

Tell readers about the proposed application in simple, plain English. What is the business and what rules apply? What do your tables represent? How are they related in simple terms?

[June7]

ID is designated as primary key in tblVehicle. This is the value that should be saved as foreign key into a number field of tblInput.

Advise not to use exact same field name in multiple tables.