How to make a Print Receipt have my payment table available on
I'm having trouble structuring my print receipt. We run a bridal shop. Which we take deposits quite a lot on our products.
Attached is how I have set up my relationships
My print Layout is set to show records from "Invoice Data table" which shows all my line items. All my totals and taxes even the balance(Which Calculates Invoices:Grand Total - Payment Info:Deposit) shows up on the layout, but when it comes to my "Payment Info" it does not show up.
The "Payment Info" table is to keep a record of all my deposits for that one invoice. I know the problem is a relationship that have not made. Not sure which way to go. Do I need to add a Primary Key Field to may "Payment Info" and trace it back to foreign key field in "Invoice" Table I need to add (Deposit amount, Deposit Date, Payment Type). Or should I say use a portal. (In portal I would have a limited layout Style)
Hope I explained correctly thanks in advance