O'Reilly logo

Microsoft Access 2013 Inside Out by Jeff Conrad

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 table validation rule for web apps

Table validation rules are handy when the values in one field are dependent on what’s stored in another field. You need to wait until the entire row is about to be saved before checking one field against another.

In the Restaurant App you have been creating, we need an Appointments table to track day to day appointments of managing the restaurant. This table requires a table validation rule. Click the Table button in the Create group on the Home ribbon tab to get started. On the Add Tables screen, click the Add A New Blank Table link to begin creating a new table in Design view. Define that table now using the specifications in Table 3-6. Be sure to rename the ID field Access provides for you to AppointmentID ...

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