Value List - Duplicate items not showing in the list
I have a field as the foreign key for lookup in another table created via relationship. I have a drop down list, and it is showing 2 fields (last name and first name). Unfortunately, the drop down list show only 1 entry and hide those duplicate last name.
Is there any solution I could show all records entry?