create the Stocks table


The Stocks table will be used to record dividends and interest for your stocks and mutual funds. The table below shows the fields we'll create for the Stocks.

Field Name

Type

Auto-Enter

Validation

Storage

Identifier

Text

  

Indexed (minimal)

Dividend Date

Date

Creation Date

  

Last Modified

Date

Modification Date; Prohibit modification

  

Dividend

Number

 

Numeric only; Always validate

 

Interest

Number

 

Numeric only; Always validate

 


With Investment Minder open, choose File > Define > Database. The Define Database dialog box appears.

Click the Tables tab at the top of the dialog box. Enter Stocks in the Table Name text box, and then click Create.

Click the Fields tab. Ensure that Stocks is the current table, define the fields listed in the table above, set the field options, and click OK.

In Layout mode, select the Stocks layout from the layouts pop-up menu at the top of the status area. We'll modify this default layout to make it look like the Savings layout.




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

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