I have seen in AX a relation in a table on one field. Something like this: Table1.field1 = Table1.field1. What is the purpose of having this relation?
I know it’s required by the feature for renaming primary keys, and there may be other cases when the relation comes handy.
Dear Martin,
Could you please address the content in your reply…
it’s required by the feature for renaming primary keys…
a)do you mean for changing primary key from old one to new one, the old one should have relation itself in the table.
For example, you want to rename item A001 to B001. The relation is define for the whole table, not for individual records, so it’s not meaningful to talk about relation to the new or the old value.