Drop-Down List Value Duplicates Not Showing
I have a drop-down list of names which pulls values from a field in another table. It's set to show values from the First Name field, while also showing values from the Last Name field, and sorts by the first field. But any duplicate first names don't show up. So if I have three "John" names in there, only one shows up.
How do I get it to not omit duplicates?