We use look up fields to multi-select Rooms from a Locations table and are filtered based upon a Site look up field in the same form.
This works fine on first edit of the form but when we go back in to the form, we have to delete the Site value and re-select the Site (which deletes the Room data).
What are we missing?