Mulitple Inserts on Single Page?

We got the autonumber and drop down boxes to work for inserting participation records, but then I realized that the drop down box for dancer email would be really big since there are hundreds of dancers.  Is there a way where the html form would list every dancer, have a fundraiser drop down box for each one (or maybe one that would control all of the dancer's fundraising) then have a spot next to each one to enter the amount raised?  We would also need to do the autonumber thing.