I have a table "Activities" which has a field Activity_type, and a possible Participant_type
I have a value list defined for Activity_type, and now I want to customise the participants in an activity by a custom Participant_type. Here are some values. I would use the Participant_type to default to the "mapped" related Activity_type, but allow the user to over-ride this with a drop down value list.
there are 56 activity_types at present , which might expand to say 100?
To create a table was my first choice, but I then thought that for such a small dataset using Field repetition may be better?