FILESOFT ACADEMY / COURSE 2 / LESSON 2
Keep the next action
with the right contact.
Print this worksheet or save it as PDF.
Back to the lesson ↗Build and compare
- Back up the closed Lesson 1 working file.
- FollowUps: five default fields plus ContactID, Task, DueDate and Status.
- Contacts::PrimaryKey = FollowUps::ContactID; related creation on FollowUps only, cascading deletion off.
- Task, DueDate and Status required; due date valid with four-digit year; status Open or Done.
- Contact Follow-ups based on Contacts, with three fields inside the FollowUps portal’s first row.
- Rivera: two tasks, one Done and one Open. Morgan: one different Open task.
- Contact count unchanged; contact statuses and notes preserved.
- Correct invalid entries and confirm persistence after reopening.
Explain the design
Why does each task need its own PrimaryKey?
Which ID repeats when one contact has several tasks?
How is contact status different from task status?