Subtables

Hi,
Ok I still don't get it. I've posted about this over here before, but I still don't see how so...... - how do I do subtables? Say we have a number of parties being held, and a certain total no. of people going to them - for each party, we have info on where it was held, theme, etc., and for each of the people we know their names, ages, sex etc. Now obviously lots of people were at one single party, however each person could have gone to > 1 (ie. a many to many relationship). We'd like to be able to search to see if a particular chap was there, given a certain party, and look up his age and so forth, and also, given a certain guy, we'd like to see which are the parties he attended and who was at each ONE and so forth........
how do I do this?

Thanks for all your help,

SMF.

-- 
It IS the end of the world as you know it! You can now
get PAID to listen to CDs and MP3s!!! Click on this link:

www.soundom.com/cgi-bin/affiliate.cgi?id=sexymf

And start feeling fine! :)