VB Excel add-in - How to setup field LOV's based Other Fields Value
Use Multiple LOV’s for a field based on selected value of other Field
We have a field called Qualifier Type which can contain Multiple values as Below.
- Bill-To Location
- Ship-To Location
- Transaction Reason
Based on the fields value for Qualifier Type, we need to Display the LOV for the Qualifier Value Code with the relevant LOV which should be dynamic.
For Example if i choose value as Bill-to Location for Qualifier Type then Qualifier Value Code should be populated with values for Bill-to Location LOV.If i choose value as Ship-to Location, then the Qualifier Value COde should be populated with values for Ship-to Location LOV.