Reporting all information
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.