Link fields from multiple selection list to a field from a sharepoint list

formdesignerGSO — Tue, 11 Sep 2012 15:23:03 GMT

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

General