Two portals, report all information
I am a farmer, and I have a lot of fields that I farm. I am trying to match invoices with fields. I have a table called Fields, another called Invoice, and another to share the relationship called share. I can currently input data into my invoices and link it to certain fields, but I can not figure out how to report all the information. I made three reports. each based on one of the tables. The problem is that they show all the records from the table from which I am basing the table, but only the first related record. For example if I build a report off of the field table, It shows all the fields, but only the first line of invoice.