Hi Guys,
I have two combo boxes, cmb_ProductFamily and cmb_ProductLine
cmb_ProductFamily properties:
Items: Sort(Distinct('Products', Title),Result)
DefaultSelectedItems: {Value:ThisItem.Product Family'}
cmb_ProductLine properties:
Items: Sort(Distinct(Filter('Products',Title=cmb_ProductFamily.Selected.Result),product_line),Result)
DefaultSelectedItems: {Value:ThisItem.'Product Line'}
Please consider this scenario...
I make a selection using cmb_ProductFamily, I then make a selection to cmb_ProductLine. I then choose a different option in cmb_ProductFamily and the value in cmb_ProductLine doesn't clear, potentially allowing my user to enter an invalid selection.
How can I clear the value in cmb_ProductLine when cmb_ProductFamily changes?
