Imported primary key field to auto calculated pk field.

[fmow]

I am planning to import a series of records, about 6000, with a XXX YY type of serial as primary key, XXX for ascending serial and YY for year data. I am then planning to use filemaker to take it from there and continue with any new inputted record with the same convention but, of course, auto calculated. This all seems straight forward, but I just want to run it by you guys in case there's some known glitch in that which I 'll have to be aware of before I begin. 

[GisMo]

You should be fine. If you're 100% confident that all of your serial numbers are unique you'll be ok for this as your primary key. For your own confidence, you can make a test simple test database to verify your import.

 

Do you have the auto-enter calculation for your serial field set up yet? If yes, you can bypass this auto-enter during the import.

 

If not, You may want to look at this function for your serial; http://www.filemaker.com/12help/html/func_ref3.33.87.html combined with year(get(currentdate))

 

Also, check this video out for your reference:

[fmow]

You should be fine. If you're 100% confident that all of your serial numbers are unique you'll be ok for this as your primary key. For your own confidence, you can make a test simple test database to verify your import.

 

Do you have the auto-enter calculation for your serial field set up yet? If yes, you can bypass this auto-enter during the import.

 

If not, You may want to look at this function for your serial; http://www.filemaker.com/12help/html/func_ref3.33.87.html combined with year(get(currentdate))

 

Also, check this video out for your reference:

'>