Reseting key fields
I have a solution with 12 or more tables, the thing is that I was tought to set my key fields with three letters at the begining like "MCD0000001...MCD0000002... and so on... But I was wondering if there is a way to rename all key fields with just numbers and also for the related tables..... I know it sounds like a lot of work and risky but I realized that the letters in the kyfield are going to be a problem later with a script I just wrote to import data and to reset the next key field values...
Thanks in advance