norbert
|
Posted: 07/08/2002, 4:55 AM |
|
Help!!!
I am having some troubles with creating and updating a ("product") table
which has a many-to-many relationsship to a "category" table:
------
A table relationship such as
"product<-N---1->category" (a product belongs to only one category)
with the fields:
product=id,name,category_id
category=id,name
.... doesn't cause any problems. I simply create a field "category" within
the 'product-table' form with type 'listbox' and set the appropriate 'list'
properties.
------
B U T what can be done in a table relationship such as
"product<-N---N->category" (a product can belong to more than one
category)???
I created the following db tables:
product=id,name
matchproductcategory=id,product_id,category_id
category=id,name
.... which equals:
"product<-N---1->matchproductcategory<-1---N->category"
------
NOW, how could I solve this category assignment (within the 'product'
form/page) in CC2.0 (asp or php)???
Did somebody have had a similar situation and did find a solution; or do you
have a idea how to program this case?
Thanks a lot for any help!!
Robert
|
|
|
|