Hello all.
I'm trying to add a cascading dropdown that has a Foreign Key, on the Watch tab, that somehow needs to pass through a repeat table, in between, from a multi-select DB Join. Man, this ones a hard one to explain...
Maybe it's easier to explain the application. I have a Condo Unit # list and a Users list. Only certain Users have access to Condo Unit # records / rows that are assigned to them. The assigning is handled with a multi-select DBjoin. I have a form where a condo unit is selected and then on the same form I need a cascading dropdown that only displays users that have been assigned to the selected condo. How do I make the cascading dropdown work with the hidden repeat list, that connects the 2 lists ids, in between?
Thanks in advance.
I'm trying to add a cascading dropdown that has a Foreign Key, on the Watch tab, that somehow needs to pass through a repeat table, in between, from a multi-select DB Join. Man, this ones a hard one to explain...
Maybe it's easier to explain the application. I have a Condo Unit # list and a Users list. Only certain Users have access to Condo Unit # records / rows that are assigned to them. The assigning is handled with a multi-select DBjoin. I have a form where a condo unit is selected and then on the same form I need a cascading dropdown that only displays users that have been assigned to the selected condo. How do I make the cascading dropdown work with the hidden repeat list, that connects the 2 lists ids, in between?
Thanks in advance.