create Text fields


Text fields can store any kind of character data, including letters, numbers, and punctuation. Examples of Text fields include addresses, comments, and phone numbers. (Because phone numbers generally include non-numeric characters, such as minuses and parentheses, they are better represented as Text fields than as Number fields. In fact, any field that can contain a mixture of numeric and non-numeric characters should be a Text field.) The table below shows the names and descriptions of the Text fields you'll create for the Main layout.

Text Field Name

Description

Account Type

Classify the investment as Savings/Money Market, Stock/Mutual Fund, CD, or Savings Bond

Bond_Serial #

Bond identification number

CD_Certificate

CD certificate identification number

CD_Institution

Name of institution from which the CD was purchased

Description

Descriptive account identifier

Sav_Institution

Name of bank or money market institution

Sav_Savings Account

Savings or money market account identification number

Stk_Account Number

Brokerage account number

Stk_Broker

Broker's name

Stk_Brokerage Firm

Name of brokerage house

Stk_Phone

Broker's phone number

Taxable

Taxable investment: Yes, No, or ?


In the Define Database dialog box (see page 10), enter Account Type in the Field Name box, select Text from the Type drop-down list, and click Create. Repeat this procedure to create the other Text fields in the table.




Creating a Database in FileMaker Pro 8. Visual QuickProject Guide
Creating a Database in FileMaker Pro 8: Visual QuickProject Guide
ISBN: 0321414837
EAN: 2147483647
Year: 2005
Pages: 115

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net