Rename and Table Relation Problem [solved]

geri79

Hi,

I need to Rename some of my Contacts. No Prob. But as Contacts are in referred in many other Tables, I need to be sure, that all this fields in salesheader, purchaseheader,...are updated.

There is my problem:
I have 6 "self-made" fields in the salesheader, which keep contact numbers for several information. I have set a table relation <contact> in the properties, but only in the 3 fields which keep company contacts, the number is updated. On the <person> fields there is still the old number.

Is there anything else to check apart the tabelrelation? I just wrote <contact> in the table relation properties without any further specfication.

any ideas?

Thanks,

geri.

_________________
geri

Quila

Hi Geri79

Try to check the field property validatetablerelation, it has to be yes in order to be renamed.

Cheers

Quila

geri79

Hi Quila,

thx, but validatetablerelation is set. I really think there is a bug... because in other tables the same fields work.

ty

geri79

geri79

Some of the records where created before the table relation was set...

So renaming can't work.

I identified these records, not too many, so problem solved. Thx.

kine

Sometime can be problem, that not whole primary key is not connected. For example, if you set relation just to one field from PK which have more fields, and the relation does not include filters for rest of the PK, the relation will be not correctly "renamed" when the value in PK is changed.

(example: On sales header you have field Ship-to Code. If there will be just relation to "Ship-to Address".Code, when you rename the Code of the address, this field will not be "corrected" (or will be corrected all values independent to customer...), correct relation of course is "Ship-to Address".Code WHERE (Customer No.=FIELD(Sell-to Customer No.)))