Valid_If for Drop Down based on previous Drop Down

Hi, I’m new to Appsheet.

I’m creating an app that tracks employees’ attendance.

Fields are
Location:
Employee:
Infraction:

There are multiple Locations and I want the Employee drop down list to be dependent on the Location drop down. The issue is that employees can be moved from one location to another. If I use a Valid_If for a Location column in a table with another Valid_If for an Employee column, then it will return only infractions from that specific Location.

I want to return Infractions from all locations for the Employee selected.

I hope I’m making sense.

Thanks in advance.

Do you have another table for location data? Then you set up ref connection between location field in attendance table, then it will generate the dropdown.