I am trying to link my health appointments to the rostering info so I can understand what shift someone was working on the day they attended a health appointment.
I have the following tables :
Health appointments
Health Appointment Date
Person First Name
Person Last Name
Person DOB
Health reason
HealthAppt_Person_ID
Person Table
Person First Name
Person Last Name
Person Staff Number
Person DOB
HealthAppt_Person_ID
Roster_Person_ID
Roster Table
Roster Date
Roster Shift Name
Person Staff Number
Person First Name
Person Last Name
Roster_Person_ID
How do I show what shift the person was working on the date of the Health Appointment (without duplications)?
Thanks in advance
Phil
.png "Luminary Alumni"){kind=icon}
