Hi, So i am looking for a way to have a query look up an appointment in a table called "Appointments" against another Table called "Workload"
The fields I wish to check against are
Appointments
Customer_Acc
Appointment_Date
Appointment_Time
Appointment_Type
and then in Workload
Acc
Date
Time
JobType
The fields I wish to check against are
Appointments
Customer_Acc
Appointment_Date
Appointment_Time
Appointment_Type
and then in Workload
Acc
Date
Time
JobType