Jump to content

Linking Databases using a key field


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

Recommended Posts

  • Newbies

I am very new to Filemaker. I have a master name file which includes a key field "SSN" I also have several other databases that I want to link by "SSN". I want to display the master name file layout, press a button to select another layout in another database that creates a new record and places the "SSN" in the new record as the key field.

Link to comment
Share on other sites

Use a portal with the "allow create related records" option selected in the relationship. Easiest method because FMP performs the work.

Otherwise you need to script the process: "remember" the master record's key field, go to the related database, create a new record, paste the remembered value into the local key field.

The "remember" can be achieved with copy/paste, global fields, or lots of other ways.

Link to comment
Share on other sites

This topic is 8231 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.