changing employees number to new set of numbers

asembereng · 2008-03-13

Hi,
I am face with assigning new numbers to existing employees numbers. We are using their current numbers as secondary keys but we want the new numbers to be the secondary key now. The current number happens to be the secondary key of so many tables. I want to know the effects of changing the keys on the Navision system. And what possible way can i do this.
Thank you.

jlandeen · 2008-03-13

The effects of changing the primary key of an existing base table in Navision can be pervasive and very bad (as there could be a lot of code designed to work using the original key). I've seen a customer modify a key on a posted table and it caused havoc in their system. It will also be much more difficult to update & maintain the database when fixes come out.

I would suggest you find a solution other then modifying the primary key.

Savatage · 2008-03-13

You're really talking about here is RENAME or do you want to retain the original # somewhere?

Are you thinking about adding a new field "Employee No2" fill it with the new # and add a key for this new field on the table?

jlandeen · 2008-03-13

Right...I guess the way I read it I thought he meant the key of the table...renaming the key of a record is certainly a lot safer!

asembereng · 2008-03-14

Just to Rename it and use the new number as a secondary key. There are so many tables with the old number but those fields are secondary keys. Is there any relationship that i can i use to make the changes on the employee table and it automatically make the changes to the rest of the tables?

jlandeen · 2008-03-14

Using the Rename function should propagate your changes to other tables - only to fields that are properly related to the Employee."No." field in their tablerelationship property.

changing employees number to new set of numbers

Comments

Categories