Creating a print layout
I'm setting up a database to handle a few differnt tasks, that all accumulate in a tax receipt. Basically, needing to give receipts to students for classes and books purchases as well has how it was paid. I have set up my receipt below and have 3 portals pulling the data from each source (class info, books, and payments), all related to the student and within a given date range.
My problem now is creating a print layout. I thought I could make a Receipt Line Item table where Receipt is now, and put the Receipt table between Student Info and Receipt Line Item. Problem is that it was combining info from the 3 tables into one line item, instead of making 3 different lines for each separate item.