I have a list with a dozen or so columns.
I have a drop down list in its associated InfoPath form, which displays all values (unique only) from Column A.
Once a value is selected, I would like all associated values from Columns B, D, E, F etc (where its Column A value is the one that has been selected) to display in a separate table in the form.
Is this possible?