Database Reference
In-Depth Information
2. In the Field Name field, type agreementID .
This field name may seem odd (no spaces and a mix of upper- and lowercase letters),
but it's one of many naming conventions used by developers to help them quickly
identify fields that they've created to make the database work. In this naming conven-
tion, the field name starts with the name (or one-word abbreviation) of the table for
which it is the key field. The “ID” at the end confirms that the field is used as a key.
3. From the Type pop-up menu, choose Number .
Key fields are most often number fields. (See Keys for more information on choosing
and creating a good key field.)
4. Click the Create button and then click the Options button. See Figure 4-5 .
The “Options for Field 'agreementID'” window appears.
5. Turn on the “Serial number” checkbox and then click OK until you're back on
the Lease Agreement layout .
A serial number is created in the agreementID field for each new record you make.
It's important to know that even if you can't see the agreementID field, the serial number is
added to it when you create each new record. And if you still haven't turned on the “Add
newly created fields to current layout option” in the Preferences dialog box, do that now.
Create a few new records to watch serial numbers being created. Notice though, that the re-
cords that were already in your database don't have serial numbers yet.
Search WWH ::




Custom Search