FILESOFT / BEGINNER / LESSON 6
One contact, several notes.
Back to lesson 6 ↗Build and compare
- Back up your closed lesson 5 working file.
- Create Notes: five default fields plus ContactID and NoteText, both Text.
- Join Contacts::PrimaryKey to Notes::ContactID.
- Allow related creation on Notes only; leave cascade deletion off.
- Duplicate Contact Entry as Contact Notes; add a Notes portal.
- Place Notes::NoteText inside the first row.
- Alex Rivera: two notes. Alex Morgan: one different note.
- Switch contacts: their histories stay separate.
- Contact count unchanged; close/reopen and confirm persistence.
Explain the keys
Why may ContactID repeat while Notes::PrimaryKey stays unique?
What does the status toolbar count on Contact Notes?