Hi All,
Apologies if this has been asked before, I had a search and couldn't find an answer.
I have two linked tables: tblStaff and tblRoster.
tblRoster has fields: date, staff1, staff2. My design requires both staffID fields to be linked to staffID primary key in tblStaff. Access won't let me assign two 1-to-Many relationships between the same tables, unless I add a duplicate tblStaff in the relationship screen. My application is now quite complex and Id like to know if this is method is sound, or am I going to encounter some weird stuff going on? Any better method of creating this relationship?
Many thanks
Alistair