Skip to main content
Question

Creating a report from 2 or more tables

  • Oct 18, 2024 4:01 PM UTC
  • 0 replies
  • 100 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

 

This topic has been closed for replies.

Delo
Forum|alt.badge.img+2
  • Qrew Cadet
  • Oct 18, 2024 7:24 PM UTC

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.