Share this Page URL

Chapter 3. Managing the Consistency, For... > Field Size Property - Pg. 83

Managing the Consistency, Format, and Integrity of Your Data 83 table by default in Datasheet view or as a PivotTable or PivotChart. You'll learn about the Validation Rule and Validation Text properties for a table in the section "Validating Data" later in this chapter. In essence, a validation rule for a table defines criteria for saving a record. You can also set up validation rules for specific fields. In the Filter property, you can define criteria that select a specific set of records in the table. For example, you could enter LaunchDate >#1/1/2004# in the Filter property and apply this filter when- ever you need to see data about campaigns that launch after January 1, 2004. We'll look at a number of ways to filter records in Chapter 6. In the Order By property, you specify the field by which records should be sorted. By default, records are sorted in a table by the primary key field. You can also specify fields to sort by and the sort order (ascending or descending) in queries. Tables also have several properties related to the display of subdatasheets. Subdatasheets let you view related data when you are viewing a set of records in Datasheet view. (To display a subdata- sheet, click the plus sign that appears on the left side of a record when a table, query, or form is open in Datasheet view.) Subdatasheet properties let you control which set of related records to view (the Subdatasheet Name property), which fields link the related records (Link Child Fields and Link Master Field properties), the height of the subdatasheet, and whether subdatasheets are ex- panded by default. When you create a table, Access sets the Subdatasheet Name property to Auto, provided that you haven't changed this setting. Access creates a subdatasheet for a table that's in a one-to-one relationship or on the "one" side of a one-to-many relationship. You can insert a sub- datasheet into a table by specifying a table or query in the SubdatasheetName property (or by choosing Insert, Subdatasheet when a table is open in Datasheet view) and then setting the Link Child Field and Link Master Field properties to a field that links the records in the main datasheet with the records in the subdatasheet.