Thanks for that. I've already got a couple of other tables set up and a form with drop down menus for assigning the tasks but I hadn't thought of the assignments table. Sounds like that'd work to me. I'll let you know how I get on...thanks!
James
I'm putting together the staff rota for the some graduation ceremonies and I want to ideally give each staff member a personalised rota showing what they are doing in each ceremony. I've currently got a table where each record is a ceremony and then each field corresponds to a particular task...