I need to populate a repeating field with unique values from another field on a related table, with each value being its own repetition.
Set Field [Table1::RepeatField ; List ( Table2::Data) ]
And that pulls all of the items from Table2::Data and puts them all into the first repetition of Table1::RepeatField.
I'd like to know how to:
1) Return only unique values from Table2::Data
2) Put each unique value into its own repetition in Table1::RepeatField rather than all into the first one.