Rename- Searching in Not Related Tables

nav_devp

Hi All,
One of our customer is facing a problem while renaming a particular field(part of key).
System pops up the dialogue box, showing its modifying records in many of Navision tables (this tables has got nothing to do with the table that user is modifying), every time seems to be running through different sets of tables.

This particular table in question is not defined in the TABLERELATION of any of the field in whole system.

We can take the approach of Delete+Insert instead of Rename, but i'm wondering why this is happening ??
Has anyone came across this problem before?? any ideas , how to resolve it?

Any help in this matter would be appreciated.

Regards.

ara3n

Navision doesn't know that

This particular table in question is not defined in the TABLERELATION of any of the field in whole system.

So it has to go through all the fields in all the tables to find out.

delete insert is the way to go.

garak

ara's right. Use delete and insert for long renames.

Take a look here http://www.mibuso.com/forum/viewtopic.p ... ght=rename

nav_devp

Thanks both for the reply.
As I said, I understand delete+insert, is one way to go about it but I want to know why only in the case of this table, system is behaving the way it does.
Because, all other places, rename is quite quick, without any dialog box.

ara3n

rename is always slow the first time on any table,
It's faster after that.
It also depends on how many fields are on PK field.