I have a custom List in SharePoint that has a infopath form that users populate the fields in the form to fill out the list.
I have one of the fields in the form pulling from a sharepoint list to populate a LookupMultiType field chooser
I want to have the user pick the field then be able to populate another field based on the selection of the multi type field.
Example
List 1
Column 1(color) - column 2(material)
Red - brick
brown - wood
white - marble
If the user selects red and brown I want the material field to be populated with material brick, wood