[ic] table-editor and many-to-many relationships
oleg at eville.us
Sat Oct 14 14:22:30 EDT 2006
I am trying to use the table-editor to design a page where customers can
enter their own products. It seems to be an extremely powerful feature
but I've hit a roadblock and can't find any helpful documentation for
something that should be pretty common.
My products have a many-to-many relationship with several other tables.
For example, a product can have more than one category so I've got a
categories lookup table and prod_cat table to assign them one to another.
I have been trying to use the link-table functionality to create these
assignments as the new product is entered, but it doesn't seem to be
working. Ideally, I would like to list the records from my categories
table as checkboxes or perhaps a multi-select box and let the user select
any number of them. Then as the new product is entered it not only
appears in the products table, but also adds a record to prod_cat for each
Has anyone been able to do this? Is there an easy way in Interchange to
insert multiple records into assignment tables when you are entering a new
product outside of the admin UI?
Any suggestions would be greatly appreciated!
More information about the interchange-users