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.
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.