Hi there, I have an access database where I input all staff (Table_AllStaff). In this staff list I indicate if someone is a sub teacher with a yes/no checkbox, they also have to be a current staff member which is also indicated by a yes/no checkbox.
I have created another table (Table_Programs) that lists our programs, days the program run, and the hours of the programs.
I want to create a third table that joins my main table with the program table to create a substitute availability calendar/report. I have tried to build relationships between the tables, but have been unsuccessful as I keep getting a "No Unique Index found for the reference" and I don't know why that's happening.
What I want to do is have all of the sub names populate on the third table where I can select the programs they are available/qualified to sub for so that I can generate a sub list which clearly shows the name, contact info, and the specific availability for each of our subs.
If anyone is able to offer any assistance it would be greatly appreciated. Please let me know if you need more information.
Thanks in advance!!