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.

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.