Creating a Report based on two tables

Discussion created by mklimow on Aug 26, 2014
Latest reply on Aug 26, 2014 by keywords


I am trying to create a report that uses two different tables and combines them into one long list of both based on the find criteria.

I was wondering if there was a way to do this.

For instance:

I have two tables called Tool and Equipment.

I am trying to create a report that takes the payments from each of these and puts them in per month, for each tool/equipment.

I want both of these to be in the same report, listing what tool and what equipment it is.

I currently have a report that uses a list view of all of the tools to do this, but I recently found out they also wanted equipment to be added as well.

I am just unsure of how I can do this without exporting the records from each table everytime i run it and importing them into a new table to combine them into one table to run it.

Can you let me know if you know of anyway this can be done.