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
