[ic] table-editor and many-to-many relationships

Oleg Raskin 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
category selected.

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 mailing list