| 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.
|