Skip to main content
Question

Cascading Drop-down - Multi-select field


Good Afternoon

Can i create a cascading drop-down for the following set-up and if so, how:

Parent: State
Child (Multi-Select): Medicaid Contracts

Thanks,
Lashell

------------------------------
Lashell Thomas
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
There is not a way to have a cascading behaviour when you use a multi select field. This is only possible when you have proper relationships. You will need to have a Master table of states and then a Master related table of child Medicaid contracts.

Then on your transactions table you will also have relationship for one state has many transaction records and one Medicaid contract has many transaction records.  But on that latter relationship he will set the reference field to be conditional that once you have chosen the state on the transaction to only show Medicaid contracts for that state.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------