I have a table of building information (name, floors, address, etc…), floors are stored as a text list. I have a form where users select the building name from Dropdown BUILDING and the floor from Dropdown FLOOR. I would like to display only the floors for the building that was selected in Dropdown BUILDING. I am not sure how to setup Dropdown FLOOR to show only the data for a specific building.
Well I figured it out. I set a constraint on Dropdown Floor where Building Name = Dropdown BUILDING’s value’s Building Name. I am guessing that it is matching the value from the table with the value of the dropdown? But it shows all of the floors as one item.