Relationship Help

[swstrath]

AppID	Permission	PermissionType
1234	read.user	Delgated
4321	read.user	Delgated
1234	read.directory	Delgated

Permission	PermissionType	FriendlyName	Description
read.user	Delgated	Read Username	Allowed to read signed in username
read.user	Application	Read Username	Allowed to read username even if not signed in.

Hi hoping someone can help me with this. I have two tables one with a list of applications and permissions they have assigned and another table that gives the permissions a friendly name a description. The problem I have is that the permissions can have the same name, but a different description based on their PermissionType. If I create a relationship between the tables based on permission, I get both descriptions for the permission. Is there a way to get the correct description based off of the PermissionType?

[StefanoGrimaldi · Accepted solution]

hey, 

create a new column on both tables, that merged the permision and the p.type

New column = [Permision column}&[Permision Type column]

and make the relantionship between these 2 columns, 

if this helped give some kudos, if it answered your question also mark as solution for others to find it. 

[swstrath]

Perfect! So simple thanks for the help.