'RelatedTableRole' conflicts with another 'RelatedTableRole' on relation MainAccount_Offset on table Jobmaster.

Finance and Operations/AX Developer Forum
1

Hi all

i want to create a relationship from mainaccount table for 2 different fields,

for eg,

i want to assign the main account id to ledgeraccount

and want to assign the main account id to offsetaccount

to achieve this , i created 2 relations but i got error msg as

‘RelatedTableRole’ conflicts with another ‘RelatedTableRole’ on relation MainAccount_Offset on table Jobmaster.

suggestions pls

2

What are properties of these relations (especially RelatedTableRole and UseDefaultRoleNames)? When do you get the error?

3

For anyone that stumbles across this thread, and is looking for an answer, see the following blog post:

http://community.dynamics.com/ax/b/axaptavsme/archive/2015/11/16/use-one-table-for-creating-multiple-relation

4

Thanks Andrew,Your reference just solved my problem.Thanks once again.