I have been searching the forums for possible similar information on similar topics, but not found anything, so apologise if this has been addressed.
I have 1 form containing 2 standard fields to allow a combination to be selected such as
Select A | Select B
ID1 Option1 | OptionA
ID2 Option2 | OptionB
ID3 Option3 | OptionC
ID4 Option4 | OptionA
ID5 Option5 | OptionB
ID6 Option6 | OptionC
I have a second form, which has a DBJoin element to display a drop down to display the Select field A. This works correctly.
What I am trying to achieve, is to display a non editable field purely to display the content of Select B, based on the the same ID of the option chosen in Select A.
So, if we select Option 1 from Select A, then the read only field displays Option A.
My understanding is to set this field also as a DBJoin field, can this be set to render as Auto-complete, select the appropriate table and value, but not sure what the query string would be.
Any nudges in the right direction would be much appreciated.
I have 1 form containing 2 standard fields to allow a combination to be selected such as
Select A | Select B
ID1 Option1 | OptionA
ID2 Option2 | OptionB
ID3 Option3 | OptionC
ID4 Option4 | OptionA
ID5 Option5 | OptionB
ID6 Option6 | OptionC
I have a second form, which has a DBJoin element to display a drop down to display the Select field A. This works correctly.
What I am trying to achieve, is to display a non editable field purely to display the content of Select B, based on the the same ID of the option chosen in Select A.
So, if we select Option 1 from Select A, then the read only field displays Option A.
My understanding is to set this field also as a DBJoin field, can this be set to render as Auto-complete, select the appropriate table and value, but not sure what the query string would be.
Any nudges in the right direction would be much appreciated.