No unique index found for the referenced field of the primary table

[Pav90]

Hello,

I am trying a to build a slot booking database in which users will be able to book slots (ranging from 1-30) on a particular day for a specific site (location).

When trying to build the relationship between slot in tbl_available and slot in tbl_appointment i get the following error "No unique index found for the referenced field of the primary table"



the same error pops up when trying to build a relationship between site in tbl_available and site in tbl_appointment.

Can someone please explain to me why this happens?

I need both relationships to be 1 to many

thank you for your time

[Rawb]

It's happening because tbl_appointment includes date in its Primary Key. This means that it's possible to have multiple entries with the same slot and site values in tbl_appointment but not in tbl_available.

Also, you should stay away from using reserved words like date in your Tables. It can cause confusion and make it difficult to properly reference Table data on Forms, Reports, and in VBA code.