Forum Discussion

maximus1's avatar
maximus1
Frequent Visitor
8 years ago
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 ...
Need Help
  • v-huizhn-msft's avatar
    v-huizhn-msft
    8 years ago

    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

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
8 years ago

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

maximus1's avatar
maximus1
Frequent Visitor
8 years ago

Thank you, Angelia!

 

I really appreciate the help! I believe that solved my problem!