"Larry Linson" schreef in bericht
...
I do not see a valid reason for pre-populating the Activity Table with a
copy of every possible activity for each applicant, especially as you
state that not all applicants records will need all the activities.

Thanks. I thought of it more as a checklist to save users work.

When you add an activity record for an applicant, provide a ComboBox from
which the user can choose the appropriate activity. A ComboBox is ideal,
because with the default AutoExpand option, you can begin typing and it
will automatically scroll the drop-down list -- you don't have to scroll
through all the earlier options to reach the one you want.

The activities depend on the job they apply to. Maybe I can offer combo
values depending on the job.

Lars