Icehouse

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.

Better Re: Composite Foreign Keys

Oh ok... just saw this other response after I saved my last post.  I wish I had more time to view all of the weblogs and keep up with all of the posts.

Although My group didnt do that, at least we now know how to correctly do composite foreign keys.  Thanks!

Re: Composite Foreign Keys

I know this is a little late, but I just saw your reply mentioning that RissRoss's blog would answer my question.  It actually doesn't answer our question since it only talks about composite foreign keys in which both fields of the foreing key are from the same table.  We were having trouble with composite foreign keys in which the fields in the foreign key are from multiple tables.

One of my group members (as you'll see when looking at our code) discovered that it worked if we just do separate alter table commands.  We tried so many ways and this is the only way we could get it to work... hopefully it was right.

Composite Foreign Keys

We have no idea how to do composite foreign keys when the multiple fields reference multiple tables. The SQL book says nothing about this situation... only shows single field foreign keys referencing a single table and multiple field foreign keys referencing a single table.

test

horray test