ziggy,

Have a look at the attached database, specially at the Qry_Octopus query (you'll quickly understand why I named it that) and at the two forms: Frm_Octopus and specially at Frm_MultiList that demonstrates what can be obtained with almost no programmation.

With some more code many interesting things can be done with this kind of data model.

I can't add any other example right now because I'm rather busy at the moment, but I could come back to you later, should you have any more questions.

Have a nice day!