Summary field from 2 tables

[tobbesfilemaker]

Hello everyone, Im trying to make a report with 2 summary fields, the problem is that they are from 2 different tables, is this possible somehow?

 

I really appreciate answers.

[Matthew F]

A little more information would be helpful... How are the two tables related, and what are you trying to achieve?  

[tobbesfilemaker]

I`ve got 3 tables, salesmen, orders and workingdays.

 

I want to make a report where the salesmen can see how much they`ve sold and how many hours they work sorted per month for example, but the problem is that how much they have sold is in one table and they`re working hours is in another table.

[Matthew F]

Are you just wanting to calculate the total sales for the month, and the total hours for each salesperson on a given month?  Or, are you wanting to show a listing of all of the orders or workdays?   What does each row or record represent in your solution as you envision it?  

 

Here are a few suggestions:

1. From a layout representing the Salesperson table, you can place two portals:  One to Orders and one to Workingdays. Add a "start" and "end" as date global fields onto this layout and use it to filter the portals to the time range that you want. 

 

2. On the Salesperson table you can also create a calculated field, using the Sum( ) function that adds up the sale amount for the related Orders table that falls within the date range defined by "start" and "end", as above. You could do the same to sum the WorkingDays data on the Saleperson table.