I was trying to do a many to one relationship and got this error. see attachment. Hotel Name to Hotel Name.
Error msg: "No unique index found for referenced field of the Primary table."
How do I fix it?
I was trying to do a many to one relationship and got this error. see attachment. Hotel Name to Hotel Name.
Error msg: "No unique index found for referenced field of the Primary table."
How do I fix it?
"Hotel Name" is not the primary key in your Accomodation table.
Change the field in your Name-Address table to "Hotel ID"
You are going to want the "Hotel ID" field in the Name-Address table and not the "Hotel Name" just as you have done with the Branch table. A query will then let you use the Hotel Name as if it is all in one table.
thanks that worked
Glad we could help and thanks for posting back with your success!