More than one "John Smith" - please choose.

[Dana G]

We have a contacts table with several thousand contacts. Inevitably there are going to be instances where two people have the same name but work for different companies. I would like to know if there is a way to have a window pop up that says, for example..."There is more than one John Smith in our system. Please select which person you would like to use." Somehow I would like to have a way for the person to select from a list of those people and have the individuals contact info fill into the correct fields.

I have posted this topic before and had several views but no replies. I'm hoping that someone out there can help me.

Thanks.

[Vaughan]

The easiest way is to use a portal to display all the matching names. Enter the name (or part) into a global field; a relationship displays matches in a portal. Some fancy calculations such as SoundEx can be used to match to phonetically similar names.

Pop-up windows are not easy to do natively in FMP, particularly under WindOS.