2 Replies Latest reply on Jun 20, 2010 3:31 PM by spaindc

    Problem with importing and keeping records id

    spaindc

      Title

      Problem with importing and keeping records id

      Post

      Hi!

       

      I'm using FileMaker Pro 11 on windows vista

       

      I have been using an online database which has suffered major changes and is about to be bought, so I came to filemaker to make sure I'll not loose the data!

       

      I'm trying to import my data into new tables... each record has a unique id I want to keep due to crossovers with other tables...

      However, filemaker won't let me import records fields into a calculation field (I want the id to be automated to make sure it's done properly and that it's unique).

       

      If I change the field to text or number I can import it... but when I change to calculation (for future records), it overwrites ALL records, which is not a problem by itself but I loose the id, which renders useless my links to other tables...

       

      HELP!!! (if you understood ;-))