4 Replies Latest reply on Aug 26, 2014 9:50 PM by keywords

    Creating a Report based on two tables



      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.