Hi,
I have a customer who requires to have the drop down that is linked to an external table with 2 Fields/Columns.
Magazine and then Project, the Magazine(Multiple Value per Row) is the Parent field so when you select the Magazine(Multiple Value per Row) it populates the Project(Return the Multiple Value per Row) field. When using Multiple value fields, it does populate the Project, but it populates it with the same field as the previous and doesn't change it to the different field.
This is just to give an idea how the fields look.