Updating Activity Records with additional data

[acalkins1957]

In my database I have an Activity Table. Activities are open or closed. I only display open activities on the dashboard. When I update an activity I actually add records in another table called tasks. The sub tasks are only displayed when I click on the activity and then a form with a sub-form opens to display the original activity and all updates below it. I would like to only have the Activity table and make updates to each record without overwriting the current data and have it display the original task with the latest update.


Activity table:

Activity table with task table

Or somehow have the tasks on the lower form displayed on the upper form in the notes section.

[June7]

Update normally means to edit an existing record.

By 'update' do you mean a new task record for an activity?

You want to display only the original task and the latest?