Jump to content

[Samples] Migration

This topic is 2933 days old. Please don't post here. Open a new topic instead.

Recommended Posts

File Name: Migration

File Submitter: LaRetta

File Submitted: 22 Nov 2014

File Category: Samples

FM Version: Not Applicable

  • Your current data exists in different programs and spreadsheets and you've decided that you want to move it into FileMaker. How do you move that data into a normalized FileMaker solution which uses FileMaker primary keys?
  • When new to FileMaker, you used self-made primary keys (with meaning) or customer name for your relationships. You now realise that was not a good idea (and it isn't) but how to change them without breaking all your relationships?

Primary keys should be meaningless and they are critical in a sound relational structure. However changing out primary and foreign keys in a relational structure can be unnerving unless you can clearly see the process. The attached file presents a simple method of switching out relational keys which will work in all versions of FileMaker (at least back through 7).

I cannot complete your migration for you nor re-serialise your table/s but I can (hopefully) show the principle behind reinitializing your relational keys in a way which is simple to implement even if new to FileMaker.

This file is presented in fp7 format to allow access to those with version 7 or greater.

Click here to download this file

Link to comment
Share on other sites

This topic is 2933 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.