I am new to Filemaker Pro, and have built two layouts for the two expense reports I need. I am trying to create grand totals for the year, and wonder how I can pull data from one layout to combine in the other layout.
Thank you for your post!
Are these layouts based off the same table or related tables?
I'm also going to move this thread from the FileMaker Community Feedback Space (which is specifically for input on the Community itself) to the Discussions Space where you should receive more views and potentially more feedback on this topic!
As tsplatypus pointed out. It's not a matter of layouts, but of what tables you are using to store this data. Both layouts might use the same table or different tables. If different tables, there might or might not be a relationship that links records in one table to records in the other.
It's all a matter of how you design your solution and you'll need to share that info with us before we can say much more. It will also help to explain what kind of data you are recording on each layout and what kind of report combining the data you want to produce.
I am building out expense reports for record releases, and want the data in the different records to populate on another expense report for yearly expenses. I have built out a layout that has all the fields I need for each individual release, as well as built a layout with fields for the over all totals of the year. I am trying to understand hoe to pull data from the individual release records into the total expense report.
So the label can look at each record release expenses individually as well as the totals for the year. Does this make sense?
It's still a matter of TABLES not LAYOUTS.
What do you see under "Tables" and "Relationships" inside Manage | Database?
My apologies. I am very new to all of this.
Figured it out!
They are the same table.
If you need further assistance, please post back with more info about the info you want to combine. It might be that these two layouts shouldn't be based on the same table after all, for example.
Since the layouts refer to the same table--presumably the same table occurrence, that's what we call the boxes found on the relationships chart, they share the same current record, found set and sort order within the same window table. Thus, you can actually copy and paste fields from one layout to the other and the same data that you see in the field on the first layout will show on the layout of the second. That may or may not produce the results that you need.
To learn more about table occurrences, see this old but still relevant tutorial on the subject:
Retrieving data ...