Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Suppose I have a multibox with 2 fields for selection: Field1 and Field2. If I make a selection in Field1, all associated values in Field2 will be displayed in white in Field2 dropdown and the non associated values will be grey. Now suppose that based on my selection in Field1, there exists only a single associated (white) value in field2. Currently, the multibox will display the single associated value in Field2.
Is there any way to not show non associated values in the multibox
If there are multiple records for field2 based on my selection of field1 it should not display as attached
Thanks inAdvance.
Presentation tab->Hide Excluded
try belowexpression in multibox
aggr(fieldName,fieldName)
Regards
Presentation tab->Hide Excluded
Thanks for the information Both The answers helped me to achieve.