Many-to-many in Web Form??

[Anon]

MySQL on Windows - data warehouse?

How do you represent a many-to-many relationship in a web form for input? Do you need a new page for each additional item? How does this go the other way, where you add an item, and need to add to the other side of the relationship?

And as a many to many, one would like to be able to select from a dynamic pick list, if the item is already in the database.

If there is no way to accomplish this in a web form, are there interface building tools that are NOT web based?

[kparker]

There isn't a widget (as far as I know, other than somebody's custom control somewhere) for directly representing many-to-many connections in a GUI form, if that's what you're after.

But your second question sounds like you're after the more common situation, where you have items that will be part of a many-many relationship, but you're adding them one at a time, so at any given time you're only needing to related your one new item to n items on the other side.

If this is all you need, it's easy enough: just use a multi select. You'll still need some way to add items to the select if the related item isn't already there; this can be as simple as linking to an ADD page, or as complicated as lots of fancy javascript to keep the user from needing to "leave" the current page.