I have two tables: Contacts and Properties
The fields in the Contacts table includes name, company, job title, address, etc. (address being the most important).
Some of my contacts share the same address, so what I'm trying to do is display a list of unique addresses in the properties table with all of the contacts associated with that address showing too. I tried to do this by setting up a field in the properties table named address as well, and wrote a calculation to try to auto-enter values without duplicates.
Here's what I've tried:
ExecuteSQL("SELECT DISTINCT Address FROM Contacts" ; " " ; " ")
What shows up in the address field in the contacts page is a simple "?"
What do I do? Pretty new to filemaker so please help.