Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Setting Primary Key


Recommended Posts

I have created a database from importing the database from a comma separated text file. The first line of the text file contains the field names. I now want to use one of the fields as a primary key. I can not find anything in the define database that allows me to do that.


Do I need to create a new field before I import database and allow filemaker to set an internal record Id for the primary key? The field the currently in the database is unique and would make a better primary key.



Link to comment
Share on other sites

FileMaker doesn't have a checkbox/option like Access to define a specific field as a Primary Key. You can use any field as a primary key and many developers have a field naming convention to remind themselves which field they are using.


The main thing you should really do with your field you want to use as a primary key is to turn on th validation option to ensure the values are unique and not allow the user to override that.

Link to comment
Share on other sites

The best kind of primary key is an auto-enter serial number.

You can create a number field with auto-enter serial number before import and, upon import, choose to have auto-enter options enabled. Then your new records will have a serial number that is unique, and when new records are created or imported, you won't have any validation problems.




Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...

Important Information

Terms of Use