Hello Michael,
If I understand correctly, you need to remove "duplicates" from a reference list of value in an authoring form.
I guess those "duplicates" are here because the display card associated is a concatenation of multiple fields.
This concatenation not being unique, then it displays "duplicates".
But in reality, those are not duplicates, as they are each linked to a unique identifier.
Maybe as a workaround, you could give more liberty to the user to chose its referenced attribute by providing a search form on the reference:
And if required, you could even apply a picker filter based on your need.
Hope this helps.
Have a good day.
Best regards,
Alexia
Michael_bartley
Within a form, I have a field that enables users to select from a list of customer ID's. However, I need to filter the list using a child table with additional attributes, so the list I'm presenting the users with contains what looks like duplicate records.
Do you have any suggestions for an approach I can take for limiting the list of customers to only one occurrence of each ID?
I've pasted an example below and attached the image as well. Essentially, I need to filter against customers from the table whose key is in col A, made up of Cols B-G.
When I display the customer number in the pick list, the list as it looks today is as follows:
0000000150
0000000410
0000000410
0000000430
0000000430
0000000445
0000000445
0000001000
0000001000
0000001000
0000001000
0000001000
0000001000
But for this specific purpose, the user only cares about the customer number in column B, so I'd like the available values to be (eliminate dupes):
0000000150
0000000410
0000000430
0000000445
0000001000
I cannot just filter off of the table containing the customer numbers, because I need to filter against some of these other attributes in cols C-G.
Any suggestions regarding an approach I can take? Thank you!