how do i take two columns in a form, first one referencing a table, second one referencing a different table. the options for answer in second one should be filtered based on the first answer? For example i have a table called States with columns ID, STATE and a table named Cities with columns ID, CITY, STATE. In the Cities table the STATE value is the ID of the STATE from the States table. When user chooses the State in the dropdown on the form, the city options should only be cities within that state. I've been able to accomplish this by referencing my state table for State field on the current table, and referencing my cities table for my City field on current table. I then add a vaid if statement of SELECT(Cities[CITY], [STATE] = [_THISROW].[State]). It is showing the filtered cities correctly, however they all have yellow triangles next to them. I'm stumped on how to fix that.
LinkedIn
Twitter
