Update Product table Question

[Guest]

Hi, Can someone give me some pointers please on thisone. I have a products table which has a relationship with a recipe table. A product can be assigned to a recipe (one - many). On my update and add product pages though I can only seem to be able to assign a product to one recipe using a drop down list menu. This works fine but I would like to be able to assign the product to many recipes. Can anyone advise on what I would need to be looking at doing.

I really appreciate your help.

Thanks

Jules

[Newsgroup_User]

Don't use a drop down list. Use a check box list instead.

"Julesmg" <webforumsuser@macromedia.com> wrote in message
news:e377r5$iss$1@forums.macromedia.com...
> Hi, Can someone give me some pointers please on thisone. I have a products
> table which has a relationship with a recipe table. A product can be
> assigned
> to a recipe (one - many). On my update and add product pages though I can
> only
> seem to be able to assign a product to one recipe using a drop down list
> menu.
> This works fine but I would like to be able to assign the product to many
> recipes. Can anyone advise on what I would need to be looking at doing.
>
> I really appreciate your help.
>
> Thanks
>
> Jules
>

[Guest]

Hi Thanks John I tried that but this only creates a syntax error. I am assuming bacuase I am trying to apply two recipeID's to a product. I'm not sure how to pass this information or how to set the products table to receive it. Any help anyone? Thanks very much Jules