I have one table that holds all orders. I have another table that holds items the person bought. I have another table that shows what the person paid.
How do I create a receipt (layout) that is based on the orders table and list all the purchased items and the payments below that?
I don't want to do this using portals- this is for printing and needs to hold infinite amounts of information.