This should be simple but it doesn’t match any of the shown examples and I can’t see how to set it up.
One table consists of Routine Maintenance Tasks.
A second table contains a row for each routine maintenance task that has been scheduled (and ultimately performed). This is the work table. Each row is an instance for one of the tasks. Overtime, each routine task ought to be scheduled and performed many times.
To start, a list of the routine maintenance tasks is created. Once setup this rarely changes. Then, we want to schedule work for each task in a record that contains the scheduled date, person assigned and other tracking columns.
- Somehow, click on one of the routine maintenance tasks. This should create an instance of the task in the work table.
- Fill in the new row with scheduled date and person assigned, maybe some comments.
- Someone does the work and marks it complete and the date completed. Maybe, updating the comments.
Simple, right? But there is no way I can see to cause an action in a row of one table (without creating a new row in the starting table) to create a row in another table.
The work rows are subitems of the task row.
How should I do this?