value list duplicate entries issue
I have a DB with a value list that list contact names. This list is populated by a field 'contact:name' and shows only related entries according to 'contacts:comapny' so that the list only shows relevant contact names for the previously choosen company. The problem I am encountering is that there are multiple companies with a contact listed for 'John Doe'. When this occurs the list shows John Doe for each of the companies as it should... but other fields such as email and phone number which populate according to the contact name selected always populate with the first instance of the name. This says to me that the first instance is always showing up in the value list due to the value list not displaying duplicate entries. Is there a way I can get the value list to display duplicate entries?