RelatedTableRole property on table relation

(0) Share

Report

Posted on by maram fraij

11,873

If a table has multiple relations to the same table, the following compilation error is faced “'RelatedTableRole' conflicts with another 'RelatedTableRole' on relation XXXXXXX”. This error can be resolved by providing a unique value for the property RelatedTableRole, how can I determine the suitable value for this property or it is just a description for the purpose for this relation??

*This post is locked for comments

All responses (2)

Answers (1)

maram fraij 11,873 on at

Like (0)

Report

RE: RelatedTableRole property on table relation

Thank you
Verified answer

Jonathan Halland 11,304 on at

Like (1)

Report

RE: RelatedTableRole property on table relation

Hi Maram.

Please view this page for more details about the property: msdn.microsoft.com/.../hh803130.aspx

" text value that you type to describe the purpose of the referenced parent table in this relationship. When a table has only one relation that references a given parent table, you can use the name of the parent table. Sometimes a table has more than one relation to a given referenced parent table. In such cases the RelatedTableRole property value should describe the relation well enough to distinguish the relation’s purpose from the other relation to the same parent table."