Hi everyone, hope someone can help. currently i got 3 tables:

1. Bills: have the expenses, field: partnumber.

2. JobXactions. job hours, (also has partnumber)

3.Customers

i got the relationships: bills::Partnumber -- Jobxactions::partnumber. my problem is when i try to create a report and join the results of both tables, my summary of one of the tables does not appear, what i want is, order by customer:

partnumber totalexpenses totalhours

but only appears the summary of the totalexpenses or the summary of totalhours, but i cant figure out how to have both in the sub-summary.

You need an extra table, a join table between Bills and JobXactions, the new table often named Itemlines, is actually where the summary report layout belongs to, since it's here where the most atom data reside - Investigate this template:

http://www.databasepros.com/FMPro?-DB=resources.fp5&-lay=cgi&-format=list.html&-FIND=+&resource_id=DBPros000717

--sd