Only foreign key constraints are allowed on this table.

Best Practice Error

Only foreign key constraints are allowed on this table

How to rectify this best practice error.

For Custom Table

1. Export table to XPO
2. Edit it with text editor, and change
   • from: EnforceFKRelation 1
   • to: EnforceFKRelation 0
3. delete table in AX, synchronize
4. import  xpo file

For Standard  Table

Some custom relation table may have some error on standard table, we can fix this  best practice error using same trick as above, but for this one lets check on XPO file and change REFERENCETYPE value.

1. Export table to XPO
2. Edit it with text editor, and change
   • from: REFERENCETYPE  NORMAL
   • to: REFERENCETYPE PKFK
3. delete table in AX, synchronize
4. import  xpo file

.