4. Creating the Related Tables
Investment Minder is about to go relational. We'll create three new data tables in which to record transactions for each investment: one for savings or money market deposits, withdrawals, and interest; one for stock or mutual fund dividends and interest; and another for CD interest.
While such data could be stored in the Main table as a series of repeating fields (as one might do with line items on an invoice), it's best to record these transactions as separate records that are instead related to each investment by a key field, such as a CD certificate number, bond number, or stock name. By creating a separate record for each transaction, we have the advantage of being able to work with specific transactions (which ...
Get Creating a Database in FileMaker Pro 8: Visual QuickProject Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
