non associated fields in Multibox

[#1]

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.

[PrashantSangle]

try belowexpression in multibox

aggr(fieldName,fieldName)

Regards

[tresesco · Accepted solution]

Presentation tab->Hide Excluded

[#4]

Thanks for the information Both The answers helped me to achieve.