Forum Discussion
Solved
Still missing data after creating relationship between two tables
Hello Everyone I have two tables Contractor Expense and GVC Expense. I have created a relationship between them. My data table pulls all the information correctly from the GVC Expense data, but ...
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.