While you can use Access’s automatically generated primary keys to help you rebuild record links in Airtable, they will not be useful for maintaining links.Īfter converting a base from Access to Airtable and recreating links, I usually discard primary keys that were generated by Access, unless they are used outside of the database itself.Īirtable also does not enforce the requirement for a unique primary key, unlike Access. All linked records in Airtable must be explicitly linked (either manually or through code). However, Airtable does not enforce uniqueness of the data entered into the. In Airtable, uniqueness of the primary key is maintained internally via the record’s ID. It may be different in Airtable and that is why I asked the original question. A quick way is just to copy a whole column of data from a different field in your table and paste it into the primary field. Access connects records based on a primary/foreign key system. In database terminology a primary key is unique and allows no duplicates to be entered once set up. The first/leftmost field in a table is always the primary field, but you can change the values in this field if you want to change what shows up when you link to it from another table. I do want to caution you that Airtable handles linked records very differently from Access. Now in your primary field have a formula: Create a autonumber field (which will start from 1).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |