You post doesn't give me enough detail to know if my answer will work. Do you have 2 tables or 3?
If you have one table listing personnel and a second table listing tasks performed by the personnel, you can link the two tables by adding a PersonnelID field to your tasks field. You then create a relationship linking PersonnelTable::PersonnelID to TasksTable:PersonnelID and you are in business. That works for a one person to many tasks relationship.
I suspect though that you also have many personnel that perform the same task. If this is true, you have a many to many relationship. If so, check out the many to many relationship thread created by CarrieB and you'll find a detailed description of how to do this with a third, Join table supplied by TSGal and a different less standard approach by me.
hmm, did asearch for that thread, could not find it.
I do indeed have many tables, 6 in total, and the join table sits between the tasks and personnel tables. The personnel do more than one task, some tasks have more than one person doing them...
ps: I will look again for that thread
I think I am out of my depth, and the place I work does not let me have a quiet space to learn this. Now I am under a timeline to get this database build but I am feeling really stuck. Time for some one on one help...