Skip to main content
Question

How to make a print button getting data from 3 different tables

Newbie here, I Have 3 tables : Vendors, Purchase Orders, Purchase Items.
I want to have a print button in the 'Purchase Order' form that allows to print a PO with data from all 3 tables.

How can I do that ?

Thanks
    This topic has been closed for replies.

    You can do that from the least child if they're related. Are the tables related?
    • AyoubSalhi
    • Author
    • Registered
    • October 4, 2017
    Hey Chris, Thanks for Replying.
    Yes they are :
    Vendor -> Purchase Orders
    Purchase Order -> Purchase Items 

    How to be able to print the PO from The purchase order form ?
    You can pass lookup fields from Vendors to Purchase Orders. You can also pass lookup fields from Purchase Orders to Purchase Items. From Purchase Items, you'll have all the fields you will need for reporting purposes.
    If you want to print a traditional PO, add lookup fields to the purchase order table and then the PO form from a the Vendor Table

    Then put the report link field [Purchase Items] on the P.O. form and set the form properties to show the purchased items directly in the form.
    Terms & ConditionsAccessibility statement