I am a newbie to forums and relatively new to FM.
I seem to be suffering a recurring FM issue and need some advice.
I have a "people" database containing names and address info. Not surprisingly I have some records of people who have the same name, but obviously different addresses. My problem is, when I view the list of people via a pop-list in a portal in another database it only displays one occurence of an individuals name, even though there could be 2 or 3 people with the same name. How do I get around this this...? Each person has their own unique ID, but this seems to make little difference. My only solution so far is to differentiate names by adding a "." somewhere in the field. i.e.
Mark Jones
Mark.Jones
Mark Jones.
Am I missing something obvious?