RelatedTableRole property on table relation

(0) Share

Report

Posted on by maram fraij

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

I have the same question (0)

All responses (2)

Answers (1)

maram fraij on at

Like (0)

Report

RE: RelatedTableRole property on table relation

Thank you

Was this reply helpful? Yes No
Verified answer

Jonathan Halland 11,310 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."

Was this reply helpful? Yes No