Forum Discussion
Solved
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: Group, Subgroup, and Subsubgroup are separate tables used t...
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.
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.
