Forum Discussion

AyoubSalhi's avatar
AyoubSalhi
Qrew Trainee
7 years ago

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...
Ask about Quickbase functionality
Forms
Relationships
ChrisChris's avatar
ChrisChris
Qrew Assistant Captain
7 years ago
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.
  • AyoubSalhi's avatar
    AyoubSalhi
    Qrew Trainee
    7 years ago
    But How can I have a print button in the PO form to do that ? Not in the Purchase items PIs (because a PO can have multiple PIs ).
  • ChrisChris's avatar
    ChrisChris
    Qrew Assistant Captain
    7 years ago
    The PO form should have an embedded report listing its children Order Items. If you use the provided print option under the "More" menu, you will see in the Print preview, the embedded list of Order Items child records.