Share this Page URL

Chapter 3. Managing the Consistency, For... > Table Properties - Pg. 82

Managing the Consistency, Format, and Integrity of Your Data 2. 3. 4. 5. In the Relationships window, right-click the line connecting the tables whose relationship you want to apply referential integrity to, and then select Edit Relationship. In the Edit Relationship dialog box, click Enforce Referential Integrity. Select the Cascade Update Related Fields and Cascade Delete Related Fields options as necessary. If you can't enforce referential integrity because data in the tables violates its rules, use the Find Un- matched Query Wizard to identify the records that need to be changed. 82 Table and Field Properties In Chapter 1, you saw examples of how to use field properties. We set the Caption property of the Greeting field to create a default label that's displayed as the column heading for the field in a datasheet and when the field is included on forms and reports. We also set the Field Size property to allow more characters to be entered in that field if necessary. In this section, we'll first look at the group of table properties and then we'll examine several prop- erties for fields. We'll describe the Field Size property in more detail--specifically the field size settings for a field with the Number data type, and we'll set properties for some of the fields in the HelloWorld database as we go along. Later in this chapter, we'll work with properties that you can use to manage accurate data entry and keep your data consistent--the Input Mask property, the Format property, and the Validation Rule property. Table Properties From time to time, you'll set table properties in the Table Design window. More often, you'll set table properties when you work with the table's data, sorting and filtering records in the table, for example.