AnsweredAssumed Answered

How to make a Print Receipt have my payment table available on

Question asked by WilliamSouth on Jun 18, 2014
Latest reply on Jun 18, 2014 by WilliamSouth

Title

How to make a Print Receipt have my payment table available on

Post

     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

      

Screen_Shot_2014-06-18_at_8.21.00_AM.png

Outcomes