I have a number of database many-to-many relationships which are
implemented using associative tables in our data model.
For example, products can be made up of several components. A component
may be used in many products. So we end up with a products table, a
components table and a product_components table.
What is/are the best way(s) to code this in ASP for:
- Display of the currently selected set of values
- Entry/Update of the value set
Anyone know of web sites that might have examples of this?
Thanks,
Michael
P.S. Our database is SQL Server 7.0