Forum Discussion

AyoubSalhi's avatar
AyoubSalhi
Qrew Trainee
8 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
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
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.
ChrisChris's avatar
ChrisChris
Qrew Assistant Captain
8 years ago

you can create a form for printing.

Make a new form in PO having only the fields you want to print.

Make a new URL field in PO with the code below:


URLRoot()&"db/"& Dbid()&"?a=printr&dfid=##&rid="&[Record ID#]


dfid=## << put the form ID# of the print form you want to use for printing.

The form ID can be found in your list of forms for the PO table.