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

See my article on auto-entered ID keys at:

http://www.fmforums.com/threads/showflat.php?Cat=&Board=articles&Number=41246&page=0&view=collapsed&sb=5&o=&fpart=1#Post44859

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?

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.