Cascading Drop-down - Multi-select field

Question

Good AfternoonCan i create a cascading drop-down for the following set-up and if so, how:Parent: StateChild (Multi-Select): Medicaid ContractsThanks,Lashell------------------------------Lashell Thomas------------------------------

markshnier__you · Answer

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
------------------------------

markshnier__you · Answer

LashellI will respond to your message here ion BOLDMessage From: Lashell ThomasThis make sense - let me added a little more detail.The won't get to select the state directly.&nbsp;I have a staff table and they are assigned to a state in the table. OKthe staff table would have the relationship to the transactions table - they would choose the staff member and the related state would automatically show and then I want the Medicaid contracts for that to show with the option to multi-select. OKLashellIt does not matter how the state gets selected / populated just so long as it is populated before the drop-down for the Medicaid contract is populated.&nbsp;&nbsp;------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

markshnier__you · Answer

LashellI will respond to your direct message here in BOLDThe following message has been sent to you in response to your discussion message.View inbox and reply to the message onlineMessage From: Lashell ThomasIf it&nbsp; helps - I know how to set-up a cascading drop-down with the tables already.&nbsp;&nbsp;The part i am stuck on is if i can use a multi-select field for the Medicaid Contracts instead of a the default lookup field. The normal cascading drop-down only allows one value to be picked.The CDD Conditional Drop down only work when selecting one choice from a relationship.&nbsp; It does not work in a multi select field type.&nbsp; &nbsp; You would have to set up a mini to mini relationship where one transaction has many Medicaid contracts and one Medicaid contract get used on many transactions. If that data entry is too slow a method to be adding the child records then you could email me to my email address directly and we could discuss a development project to allow you to quickly select child records to add for the transaction Medicaid contracts.------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

Forum Discussion

Cascading Drop-down - Multi-select field