I would like to know how to best wet up tables to handle the following situations.
I have employees some of whom work at multiple locations.
Locations have more than one employee assigned to them.
Work tickets are issued to specific locations.
I want the employees to see the work tickets that are either new or incomplete when they check into a specific location and not the work tickets for every location they work at. I know how to do this in a relational db but how do I do this in Appsheet?