I have a database of developers of affordable housing projects in the US. Developers build many different projects that are located in many different states. Each housing record in the database will include the developers phone number along with other information.

When I do a search that includes all the housing projects for a certain area the database gives me a list of all the developers phone numbers for this found set. Is there a way that FM will extend this found set to include all other housing projects that are using the same developer’s phone numbers for the whole database?

There a few different ways to do this I guess but you can try this. Create a new self join relationship keyed on your phone number field. As simple Go to Related Record (Show only related records, match all records in found set options checked) should give you all the related self join records of your found set.

So after you have your found set, if you run that script step it should return all the records that have the same phone number in your found set.