Forum Discussion
Group and Subgroup table using non unique values
Sorry, couldn't even figure it out the correct vocabulary to ask :(
I have a product table from the server that looks like this:
Product Table
Group, Subgroup, and Subsubgroup are separate tables used to characterize the product.
Group Table
Subgroup TableSubsubgroup Table
I'm not able to relate all of them due to the non-unique values. (there is no empty cell)
Any thoughts on how to make this work? :)
Add calculated columns that concatenate the IDs to get keys you can create a relationship on. If the IDs might be more than 1-digit ever, be sure to add delimiters.
I.e.
Subgroup Key = [Group ID]&"|"&[Subgroup ID]
Subsubgroup Key = [Group ID]&"|"&[Subgroup ID]&"|"&[Subsubgroup ID]Note that you shouldn't have a problem creating relationship to the Group table with just [Group ID] - it's only the other two you have to do the above for.
3 Replies
Add calculated columns that concatenate the IDs to get keys you can create a relationship on. If the IDs might be more than 1-digit ever, be sure to add delimiters.
I.e.
Subgroup Key = [Group ID]&"|"&[Subgroup ID]
Subsubgroup Key = [Group ID]&"|"&[Subgroup ID]&"|"&[Subsubgroup ID]Note that you shouldn't have a problem creating relationship to the Group table with just [Group ID] - it's only the other two you have to do the above for.
