relation many options to many products

[hara_m]

hi there

may be a simple problem for the experts here. I am working on a product database like this:

products-table

- product_id (P001...P999), productname_name)

options-table

- option_id (OPT001...OPT999), option_name, for_product (maybe P001,P005;P006, P999)

the problem i can´t solve is that many options are avaible for many of the products.

i want to see the "option_Name" in the Products layout through a portal.

but i have no idea, how the relationship would go in this case.

any ideas out there?

many thanks hara_m

prodOpt.fp7.zip

Edited March 8, 2006 by Guest

[comment]

Try it this way?

prodOpt.fp7.zip

[hara_m]

thank you very much for your fast help. works great and is exactly solving my problem.

Edited March 9, 2006 by Guest