Forum Discussion
Still missing data after creating relationship between two tables
Hi maximus1,
Because the relationship between 'GVC Expense' and 'Contractor Expense' is n:n, so the code 11 is missing. Please try use the [Job code query] in 'Job code' table, other fields come from ' Contractor Expense', and check if it works fine.
For merging two tables to one in Query Editor, please review the detailed steps here.
Best Regards,
Angelia
This is what my total invoice column SHOULD look like, but when I combine it with my other table. This one particular item, job code 11, does not show up.
Hi maximus1,
Because the relationship between 'GVC Expense' and 'Contractor Expense' is n:n, so the code 11 is missing. Please try use the [Job code query] in 'Job code' table, other fields come from ' Contractor Expense', and check if it works fine.
For merging two tables to one in Query Editor, please review the detailed steps here.
Best Regards,
Angelia
Thank you, Angelia!
I really appreciate the help! I believe that solved my problem!