Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

table relations

I have a problem setting up specific table relations.   I have 3 tables: value entries, item category, product group Following data as an example:   Item categories: 1: wooden beams (related pr...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    Hi Anonymous,

     

    If you have the dimensions [Item Category] and [Product Group], you don't need to repeat them in the [Value Entry]. I think the relationship should be like below.

    One category has many groups, the groups are in the [Value entry]. Please refer to the snapshot below.

    table-relations

     

    Best Regards,
    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

Hi Anonymous,

 

Please share a sample that we can download or copy. Don't share anything private.

Just see from your description, there could be some loops. Maybe you need to adjust your model.

 

Best Regards,
Dale

    • v-jiascu-msft's avatar
      v-jiascu-msft
      Microsoft Employee
      7 years ago

      Hi Anonymous,

       

      If you have the dimensions [Item Category] and [Product Group], you don't need to repeat them in the [Value Entry]. I think the relationship should be like below.

      One category has many groups, the groups are in the [Value entry]. Please refer to the snapshot below.

      table-relations

       

      Best Regards,
      Dale