I created an application with 4 databases

1 client
2 invoices
3 line items
4 products

The client is the parent to invoices (1 client records to many invoices)
Invoices is a parent to Line items   (1 invoice to many line items)
Line Items is the parent to product (1 line item to many products)

I created a form in the client database that has all the client data and a subform that has the invoices associated to that client and the invoice form has a subform of the line items associated to that invoice so from that one form I can see the client invoices and line items.

The subforms are of the type form not table. If I try to add a table subform that has a subform I lock up the database and have to go into server admin and unlock the database (did not release with Sunlock)  I guess it makes sense that a table could not display a subform 

So what I have is the client record form with the Invoice subform  as a form that has a table subform of line items. When a search is made the client data appears the invoices show 1 at a time (or use table view Shift f6 to see them all at once)in the subform and a table with all the line items displays.

My intent is to now use @formresultsettotal and associated programming to calculate invoice totals and total owed by customer.
(Finally the question)

Do I use the @formresultsettotal and associated programming from the parent Client database form or the child form it relates to?

Also do you see any fatal floors in my thinking?

Thanks

Thanks for the help