AnsweredAssumed Answered

Have multiple columns in dropdown from external list?

Question asked by gerardh on May 6, 2015
Latest reply on Oct 18, 2015 by gerardh

I have a list with 6 columns (70+ records), of which the first three are the selection criteria, and the last three are required to be returned into fields on the form.  Ideally it would be 3 cascading dropdown lists, each filtering based on the previous selection, and returning the corresponding 3 fields but I assume that would require maintaining the dropdown items within the form itself rather than the external list.


Is there a method by which multiple columns can be displayed as a dropdown from an external list, and on selection, pulls back the multi-column values from the selected row?


(yep, spot the newbie!)