2 Replies Latest reply on Jun 18, 2014 7:40 AM by WilliamSouth

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

    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