Hi Folks,
After a long time I’m writing this new post.
Requirement: I need to use the single table to add multiple relation on a table. For eg. I have a parent table Table1 with field ItemId and ProcessItem. Now I need to add relation to InventTable to both fields. Hence I have to create two relation with InventTable.
How to do: Add two new relation in your table as shown below.
‘
You might get an error message after this,
'RelatedTableRole' conflicts with another 'RelatedTableRole' on relation InventTable_Item on table ProcessedItemTable.
![image image](//lh3.googleusercontent.com/-ZpafMhj6ZuU/Vkmn1vjqClI/AAAAAAAABFU/kLJkm45rb3Y/image_thumb%25255B14%25255D.png?imgmax=800)
Solution to this error:
Set below two properties to each relation
1. UseDefaultRoleNames- set it to “NO”
2. Role: Give any logical name here, for eg. “Item”
![image image](//lh3.googleusercontent.com/--k5_nJDW6yo/Vkmn3mIpwxI/AAAAAAAABFk/tSFXCFzsBOw/image_thumb%25255B12%25255D.png?imgmax=800)
![image image](//lh3.googleusercontent.com/-IUGG4_LjZbc/Vkmn5tACC9I/AAAAAAAABF0/uOtM4EhKTOI/image_thumb%25255B10%25255D.png?imgmax=800)
Now compile your table, error must gone.
Write your any query/feedback in comment box and help us to improve. Thanks..!!!
-Harry
After a long time I’m writing this new post.
Requirement: I need to use the single table to add multiple relation on a table. For eg. I have a parent table Table1 with field ItemId and ProcessItem. Now I need to add relation to InventTable to both fields. Hence I have to create two relation with InventTable.
How to do: Add two new relation in your table as shown below.
![image image](http://lh3.googleusercontent.com/-jnKCUnV3im0/Vkmnzt10ScI/AAAAAAAABFE/A3J2tZS0SOc/image_thumb%25255B16%25255D.png?imgmax=800)
You might get an error message after this,
'RelatedTableRole' conflicts with another 'RelatedTableRole' on relation InventTable_Item on table ProcessedItemTable.
![image image](http://lh3.googleusercontent.com/-ZpafMhj6ZuU/Vkmn1vjqClI/AAAAAAAABFU/kLJkm45rb3Y/image_thumb%25255B14%25255D.png?imgmax=800)
Solution to this error:
Set below two properties to each relation
1. UseDefaultRoleNames- set it to “NO”
2. Role: Give any logical name here, for eg. “Item”
![image image](http://lh3.googleusercontent.com/--k5_nJDW6yo/Vkmn3mIpwxI/AAAAAAAABFk/tSFXCFzsBOw/image_thumb%25255B12%25255D.png?imgmax=800)
![image image](http://lh3.googleusercontent.com/-IUGG4_LjZbc/Vkmn5tACC9I/AAAAAAAABF0/uOtM4EhKTOI/image_thumb%25255B10%25255D.png?imgmax=800)
Now compile your table, error must gone.
Write your any query/feedback in comment box and help us to improve. Thanks..!!!
-Harry
What is the use of this relation properties(RelatedTableCardinality,Cardinality,Relationshiptype,UseDefaultRolenames and all)
ReplyDeleteIt is worthwhile reading this blog. I was searching such kind of blog for a long time but now I think I got a blog of my interest. I am thankful for these all suggestions mentioned under this blog. Owned networks Miami
ReplyDeleteYour blog helped me a lot. Thanks
ReplyDeleteThanks Kushal. Good to know its helpful. Keep in touch.
Delete