[Example] Investment Tracking (record cloning with macro)
Posted: Thu Apr 28, 2011 9:34 am
Here's an example database that could be used to track investment transactions for tax purposes.
The real demo here is a macro assigned to a button that clones the current record to a new record. This aids user input accuracy for related buy/sell transactions while selectively reducing overall input redundancy. The Table Control grid aids in selecting a record to be cloned. It became apparent that the Primary Key constraint forced the listing of each column-name in the SQL/macro. This has the added benefit of allowing selected fields to be cloned. For instance, the Date field is not cloned which allows it to default to today's date in new records as setup with SQL in the table structure.
Enjoy!
The real demo here is a macro assigned to a button that clones the current record to a new record. This aids user input accuracy for related buy/sell transactions while selectively reducing overall input redundancy. The Table Control grid aids in selecting a record to be cloned. It became apparent that the Primary Key constraint forced the listing of each column-name in the SQL/macro. This has the added benefit of allowing selected fields to be cloned. For instance, the Date field is not cloned which allows it to default to today's date in new records as setup with SQL in the table structure.
Enjoy!