I am working on a new version of a database previously written in FM11.
In order to get the data from the old database into the new version (fmp12 format), I have been exporting it to Excel then importing it. This is working so far as it goes, however I have a problem with a calculated field.
The field, ContractID, is defined as Get(RecordID)*2468
(Don't ask me why - I inherited all this stuff).
Anyway, I need to import this data to the new database, keeping the same ContractIDs as in the old system, but I can't import to a calculation field and, if I make it a normal numeric field, then try to convert it to the same calculation as before, FM will delete all the existing data in the process.
So, is there any way to do this?
Thanks in advance,