Skip to main content
Question

Creating a report from 2 or more tables

  • October 18, 2024
  • 0 replies
  • 94 views
Forum|alt.badge.img+1

I want to create a report using two tables whcih are linked. Do I create a report table where I put all the fields I want into the reports table then I can generate a report from this table?

 

Thanks

 

Delo
Forum|alt.badge.img+2
  • Delo
  • Quickbase Alumni
  • October 18, 2024

If the tables are already linked via a relationship, you would just need to pull all relevant fields into one of the existing tables and create reports based on all the fields you need.

For example:

Table A: Company, Title, Phone

Table B: Contact Name, Contact Phone, Contact Email

If your relationship includes any fields between these two tables, you simple add the other lookup fields from Table A into Table B, making all relevant fields available in Table B to create any reports you need.

Terms & ConditionsAccessibility statement