Showing the results of a found set from four related tables.
I am using FileMaker Pro 12 and I have a main self-join MS SQL table that has four other tables related to it. Three of the four tables related to it are MS SQL tables.
I need to pull data from certain fields from those tables into the main self-join table. The data that needs to be pulled are summaries based on a find.
The main self-join table is related to the other four tables by a field called Project Id, and the self-join is related to the main table, where I want to show the results, by a field called Project Code.
There are several Project ID records per Project Code. I want to show all the records related to the Project Code based on a find.
I tried to use a Portal but it didn’t work. It would always show all the records in the related tables.
You can only add a calculation or summary field to the main table.
Is there any way to do this without making another temp table to copy the field information from the other tables? What is the best way to show this information?