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
Icon for Microsoft Employee rankMicrosoft 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