• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 2. What Every Developer Needs to... > Working with Table Properties

Working with Table Properties

In addition to field properties, you can specify properties that apply to a table as a whole. To access the table properties, click the Properties button on the toolbar while in a table's Design view. The available table properties are shown in Figure 2.23. The Description property is used mainly for documentation purposes. The Default View property designates the view in which the table appears when the user first opens it. The Validation Rule property specifies validations that must occur at a record level, instead of a field level. For example, credit limits might differ depending on what state a customer is in. In that case, what's entered in one field depends on the value in another field. By entering a table-level validation rule, it doesn't matter in what order the user enters the data. A table-level validation rule ensures that the proper dependency between fields is enforced. The validation rule might look something like this:

[State] In ("CA","NY") And [CreditLimit]<=2500 Or _
    [State] In ("MA","AZ") And [CreditLimit]<=3500 Or _
    [State] Not In ("CA", "NY", "MA", "AZ")


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint