Reporting All From Related Tables

[dman]

I have two Tables. One is Fields (as in farm), and another is Invoices. I have the two tables shown in portals on one layout so I can select multiples of each at the same time. I have to be able to do this to apply a certain amount of fertilizer or chemical to several fields all at once. My problem is that I cannot report all the information. It either shows the first line of the invoice and all the fields or the first line of the fields and all the invoice. the relationship is an automatic serial number.

[comment]

Are the fields created for each invoice - or do you select them from a table of existing fields?

[comment]

On second thought, I don't think this is quite clear: your picture looks like a layout of an invoice, with a portal to LineItems and another portal to Fields. What exactly do you want to report?

[dman]

I want to be able to see a report of all farmfields summarized by Chemical name. But I dont want to have to go through farmfield by farmfield and re enter the invoice for every farmfield.

[comment]

I am still not sure of your exact structure. You obviously have more than the two tables mentioned in your original post. If I am guessing right, you have something like:

Invoices -< LineItems >- Chemicals

and:

Invoices >-< Fields

a report of all farmfields summarized by Chemical name.

If you don't have a table with individual records for each Field/Chemical combination, then the only way to produce such report is from the Chemicals table, with a portal to the Fields table (going through LineItems and Invoices).