What is wrong with my table relation? NAV 2013/2015

dmleroux

I have a need to allow lookup (and storage) of a contact name in the Sales header.
I have added a 50 character text field to the sales header and specified the table relation property as Contact.Name (no additional conditions) When using it, everything works fine so long as the name field returns no more than 20 characters (the size of the primary key field (Contact."No.").
I also made a dummy test involving trying to populate an 80 character field with the budget description via a table relation. This failed whenever the budget description field exceeded 10 characters (Budget primary key length).

For grins I tried the same thing in NAV 2015 and received an error telling me that the field I wanted needs to be in the primary key.

However if I turn off both TestTableRelation and ValidateTableRelation, then I get no error

Have I missed a memo somewhere - or is this normal behavior?

Thanks,

kine

You have missed the main part - table relation could be set only on primary key, e.g. in this case on Contact No. You cannot set table relation to something else. Table relation is there to keep the foreign key correct when you rename the related record. It means, when you change primary key. Name is not part of Primary key, thus this behaviour...

kine

You have missed the main part - table relation could be set only on primary key, e.g. in this case on Contact No. You cannot set table relation to something else. Table relation is there to keep the foreign key correct when you rename the related record. It means, when you change primary key. Name is not part of Primary key, thus this behaviour...