Selecting unique value to display in another table?

Discussion created by csorenson on Jun 17, 2016
Latest reply on Jun 17, 2016 by tsplatypus

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.