I’ve a bit of an issue that I could use some help on. I’m trying to use the Filter function to show a list of clients that appear in one table but not in another.
Here are the details:
- Client Table - contains a list of clients, codes, locations, etc.
- Schedule Table - each column represents different locations while the rows represent the clients that appear in the location specified.
- Unassigned Clients - A table that displays clients that are assigned to a location (based on the Client Table) but do not appear in the appropriate column of Schedule Table.
I’ve been toying with variates of
- [ClientTable].ClientName.filter([ClientTable].Location = (“Location”))
just to get a list of clients assigned to each location but I can’t get that part to work.
Any help would be greatly appreciated.