Hi All,
my first post here. I am not sure if I am putting it in the right section.
I have 4 tables:
TableClients
ID
ClientName
TableEmployees
ID
EmployeeName
TableBlackListedEmployees
ID
EmployeeName
ClientName
TableVisits
ID
VisitDate
ClientName
EmployeeName
TableVisits and TableBlacklistedEmployees are not linked yet. My question is, is it possible to link them so:
when in TableVisits you enter Client and then Employee that is listed in TableBlacklistedEmployees for that Client, a message box comes up or a record is highlighted (conditional formatting).
(Also, one employee may be blacklisted by more than one client)
Any help would be much appreciated.
Regards,
shinobi