Value List not diplaying all values
I am using a value list to pick out a contact from a table of approximately 4000 contacts in a portal in another table which is related by a join table. The value list uses values from the contact table, an Auto entered Id (Number field) then displays Values from a second field only, a text field (Boat Name) also from the contacts table.
I cannot get my value list to display boat names which are the same even though the Id is unique.
So where I have a boat name duplicated, two boats called "Annie" contact Mr Smith and "Annie" contact Mrs Jones I only get one in my list?
Any help please.