I am trying to build a cascading dropdown, that is, the values that display in a dependent or secondary cell are predicated by the value selected in an independent or primary cell.
For example, let say I have the following two fields:
Primary field - Document Category
Secondary Field - Document Originator
And I have the following table:
Healthcare,Blue Cross-Blue Shield
When I select Insurance in the primary Document Category field then only State Farm, GEICO and Allstate would show up as selectable values in the picklist for secondary Document Originator field.
Your advice appreciated.
Moderator's note: Edited out personal information.