O'Reilly logo

Microsoft® Access® 2010 Inside Out by Jeff Conrad and John Viescas

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Defining a Primary Key for Web Databases

Every table in a relational database should have a primary key, and web databases are no exception. In Chapter 4, you learned that you have many options available to use for a primary key in client databases. In web databases, however, you must follow the structure of SharePoint lists, which only allows the SharePoint ID field as the primary key. From a certain perspective, this makes defining a primary key in web databases quite simple—Access automatically creates the primary key field, the ID field, for you whenever you create a new web table. You cannot delete this field from your web table, but you can rename the ID field to something more to your liking, such as VendorID or InvoiceID.

If you’re an experienced ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required