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.
0
Comments
I would suggest you find a solution other then modifying the primary key.
Epimatic Corp.
http://www.epimatic.com
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?
http://www.BiloBeauty.com
http://www.autismspeaks.org
Epimatic Corp.
http://www.epimatic.com
Epimatic Corp.
http://www.epimatic.com