Refer to pictures attached of database schema, data entry screen and activity log design. There is a back-end data file and front-end application.
Modify the front-end - it has existing data entry screens for:
Projects
Clients
People
these have sub-forms with child data - see schema
Add a Delete button to the 3 screens.
The uses gets one warning - in the warning message, include a count of each child table with >0 records.
E.g. "You are about to delete project ABC. This has 15 timeheet entries, 3 people and 15 tasks attached. Are you sure?"
On deletion, log a record to the table 'zstLogActivity' with the message, e.g. "Project ABC, together with 15 timeheet entries, 3 people and 15 tasks attached.". Type = "Delete"
Must use VBA