I'm having problems. My client want to update their Item Code in Item Card.
I know i can do Rename from Item Card and Nav wil automatically update the other related table. But If i get a csv file and want to update by script, Is is possible to do?
How is the best way to do it?
I'm thinking of copy All records to one temp table, deleteall records in Item table, then insert again from temp table to Item table with new item code.
But if i do this then nav won't automatically update the related table?
Help me please,
Thanks in advance