Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

How to Define Relationship with Primary Key


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

Recommended Posts

  • Newbies
Posted

I am trying to set up a database using a auto number as the primary key. I then want that primary key to be used in another database to link the information, but I don't know how to!

Can anyone help me?!

Thank you

  • Newbies
Posted

I read that article, but it didn't answer my question.

I have a database with orders. All the vendor information is on one database with the primary key being the autonumber and then the completed information is in another.

I want to set it up so when you enter the completed information it shows up in the vendor info. I got it to do that but you have to know what the primary key is and enter it by hand you can just have it auto entered on both sides. Do you know how to do that?

Posted

If you are entering the information into an order from within a portal in your vendor file, provided that the option for "Allow creation of related records" in enabled for the relationship, then a new record will automatically be created in your related file, and its key field will automatically be set with the number from the key field in the current record of the vendor file.

Any other method you use to create new related records are going to necesssitate that the key field in your related file is set either by hand or by script.

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