I am trying to do an Access App for SharePoint.
I have two fields Venue, Service Manager.
Based on the users choice in Venue, I need to filter Service Manager.
I created a query with a parameter of VenueID and use that for the rowsource of Service Manager.
How do I re-query Service Manager with the VenueID so that the user can only select Service Managers that belong to the Venue?
Surely Microsoft saw the need for this.