Merging two tables into one report

Question

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 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 CostsJobs < Secondary CostsCurrently 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!------------------------------Andrewandrew.fry25@gmail.com------------------------------

EvanMartinez · Answer

Hi Andrew,It is possible for your use case to build out a separate reporting table that would exist to one side of all your existing functional tables in this set of relationships and populate it with the similar data from Jobs and Secondary Costs. In this table you would make the list of consistent fields between the two tables. The only issue would be are you using your existing relationship to help you populate these reports to only show the related Jobs and Secondary Costs or is it just a list of all Jobs and all the Secondary Costs? Since it is two separate relationships you wouldn't have one consistent field to relate for using in a report link since your Jobs would be using Related Job and your Secondary Costs would be using Related Secondary Costs and a report link field that pulls in a report of related records has to be based on a matching field value like Record ID or unique Job Name, etc. Unless there is a consistent field that would be the same on every Job, Secondary Cost, and Work Order that you could use to tie them all together?------------------------------Evan MartinezCommunity Marketing ManagerQuick Base------------------------------

Sign up

Login to the community