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

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

Working with Table Properties

With table properties, you can specify properties that apply to the table as a whole. To access them, click the Properties button on the toolbar while in a table's Design view. The available table properties are shown in Figure 3.23. The Description property is used mainly for documentation purposes. The Validation Rule property is used to specify validations that must occur at a record level rather than 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 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


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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