Subform vs main form calculation

[Jim]

I would suggest something like 2 tables:
Transactions table :
TranactionID (make it Autonum)
DateOfTransaction
CompanyName (for the stock)
Stock Symbol


PricePerShare
Shares
BoughtSold
Commision
TotalCost

Everytime you buy or sell it goes into the transaction table.
Dividends table:
TransactionId
Date
Amount

The tansactionID would link the Dividend with the trancaction.

[fadone]

I would suggest something like 2 tables:
Transactions table :
TransactionID (make it Autonum)

Dividends table:
TransactionId
Date
Amount
The tansactionID would link the Dividend with the trancaction.

Thanks Jim am working on your suggestion.However, does it mean that there is a one to many relationship between Transaction and Dividend tables???ie TransactionID should act as a foreign key in the dividend table???
Please clarify....
thanks

[Jim]

Yes