You will need to give a little more information.
A property match means that there are criteria that need to match.
I'm assuming location, price, number of bedrooms etc. could all be possible criteria.
The idea would be to create the same fields in both tables and to create relationships between those. Or you could use global fields to enter criteria and then perform a find in the properties table.
Thank you for your answer!
You are right, the results have to match certain criteria. I can filter the portal records, that is not a problem.
I could not even set up filters because none of the listings showed up in the portal of the buy request details page. I assume the problem was that the relationsship wasn't direct.
So I have duplicated the Sell and Buy tables and created a relationship as you see on the attached graph. Now it works.
I am just not sure that this is the right, or 'elegant' way to do this.
A portal to Sell Requests 2 on a buy requests layout should list all records in Sell Requests where the value in "type" matches the value in type in the current Buy Request record.
Can't help thinking though that this is a situation where your "matching" might need to be a bit "fuzzier" than matching a single value in a single field.
The graph is a working 'solution' Type is only matched to make some relationship between the databases. Further filtering is done on the portal itself.
The question is is this the 'recommended' or 'professional' way to get the matches from Sell Requests on a Buy Request table? Or is there a simpler way maybe even without using the Sell Request 2 and Buy Request 2 tables?
There are a number of options--including simply performing a find on a layout based on Sell Request using criteria specified from a given Buy request table.
You also may want to take a look at how the 'search portals' in this demo file work. They won't do exactly what you want "as is", but the tricks they use may be ones that you can adapt to your needs:
If you are using Filemaker 12, you can open this file from the File menu to get a converted copy of the file that works in FileMaker 12.
Thank you Phil!
I will study the attached file and look for ways to implement it in my project.