create Number fields


Number fields are used to store numeric data: the digits 09, a decimal point, and a sign (+ or -). You use a Number field when you want to be able to sort numerically (rather than alphabetically), perform calculations on the field, or use the data in a Summary field (as the object of a summary calculation in a report, for example). The table below shows the names and descriptions of the Number fields you'll create for the Main layout.

Number Field Name

Description

Bond_Denomination

Savings bond's value at maturity

Bond_Interest

Interest to-date earned by the savings bond

Bond_Price

Original price paid for the savings bond

CD_Amount

Amount originally invested in the CD

CD_Rate

CD's annual interest rate

CD_Term

CD's investment period (in months)

Sav_Initial Balance

Starting balance for savings or money market account

Stk_Commission

Commission paid when buying the shares

Stk_Current Share Price

Current quote for the stock

Stk_Number of Shares

Number of shares purchased

Stk_Price Per Share

Share price when stock was purchased


In the Define Database dialog box (see page 10), enter Bond_Denomination in the Field Name box, select Number from the Type drop-down list, and click Create. Repeat this procedure to create the other Number 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