AndrewFry
5 years agoQrew Assistant Captain
Merging two tables into one report
I was wondering if it is possible to have two tables, which have similarly purposed fields, be combined into one single flowing report?
Example:
I already have a Many-to-Many relationship built with with Work Orders in the middle.
Also, Jobs is already setup with Secondary Costs directly.
The relationships are as follow:
Jobs > Work Orders < Secondary Costs
Jobs < Secondary Costs
Currently I have a report builtin the Jobs table, placed in the Work Orders form to show all the jobs and associated prices of those jobs.
I have a 2nd report in the Work Orders form, coming from the Secondary Costs table, to show all the secondary costs of associated with the work order.
The 2 reports are almost identical, as the columns show the purpose of the data.
Would it be possible to make one single report showing all the jobs and secondary costs, in the work orders form? It would look much cleaner.
Any thoughts?
Thanks!
------------------------------
Andrew
andrew.fry25@gmail.com
------------------------------
Example:
- I have a Jobs table which has a number of fields whose purpose are the following: Item, Price, Adjusted Price, Updated Price, Qty, and Final Price.
- They may not be labeled those names exactly but the above names give the purpose of the field.
- I have a Secondary Costs table which has a number of fields whose purpose are the following: Item, Price, Adjusted Price, Updated Price, Qty, and Final Price.
- They may not be labeled those names exactly but the above names give the purpose of the field.
I already have a Many-to-Many relationship built with with Work Orders in the middle.
Also, Jobs is already setup with Secondary Costs directly.
The relationships are as follow:
Jobs > Work Orders < Secondary Costs
Jobs < Secondary Costs
Currently I have a report builtin the Jobs table, placed in the Work Orders form to show all the jobs and associated prices of those jobs.
I have a 2nd report in the Work Orders form, coming from the Secondary Costs table, to show all the secondary costs of associated with the work order.
The 2 reports are almost identical, as the columns show the purpose of the data.
Would it be possible to make one single report showing all the jobs and secondary costs, in the work orders form? It would look much cleaner.
Any thoughts?
Thanks!
------------------------------
Andrew
andrew.fry25@gmail.com
------------------------------