Forum Discussion
Creating a relationship between tables
Hi Fiona83
As the error message says one of the sides has to have unique values to create a direct relationship. You can best create a calendar table and, if needed, create relationships between it and your two current tables. The calendar table will have unique values. You could also join both tables so that you have both staff needed and available in one place.
Please mark the question solved when done and consider giving kudos if posts are helpful.
Cheers
Hi Fiona83
As the error message says one of the sides has to have unique values to create a direct relationship. You can best create a calendar table and, if needed, create relationships between it and your two current tables. The calendar table will have unique values. You could also join both tables so that you have both staff needed and available in one place.
Please mark the question solved when done and consider giving kudos if posts are helpful.
Cheers