It's difficult to understand exactly what you're asking.
It sounds like you might want an invoice report for a customer that shows the subcontractor. Your portal on the Invoices layout can do that; just add the subcontractor name field to the portal row. It's perfectly ok to have fields from other related tables in a portal row.
Additionally, I don't think you need the customer_invoice or customer_invoice_lineitem relationships as they are duplicates of what you're already using. You can relate your customers to the invoices using just the invoices table occurrence.
Again, if I've misunderstood what you need, please don't hesitate to try your explanation again.
Thank you for the reply.
Draft reports on subcontractors to do this Invoice table, too?
To make lara Subcontractor Payment Report.
relations, logic, right?
Subcontractors do not have a separate line?
Subcontractor = Subcontractor_Invoice = Subcontractor_InvoiceLine
I apologize as once again I'm not entirely sure what you're asking.
If you want a report with the invoices stating the subcontractor name, then see the post above.
If you want to show all of the invoices for a specific subcontractor then add a portal to the subcontractor layout going back to the invoices relationship.
If you need to link the subcontractors directly to the invoices for some reason, then you would need to add an invoices foreign key field to the subcontractors table and create a new relationship occurrence to the invoices.
I've attached your original file here with the first two of these scenarios. With either of these you can build a report layout for printing, if that's what you need.
Serv.fmp12.zip 36.0 K
Nick thank you
now I understand
You're quite welcome!