Greetings, 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! _______________________________________________ interchange-users mailing list suppressed http://www.icdevgroup.org/mailman/listinfo/interchange-users
Mail converted by mhonarc 2.6.15
This archive provided courtesy of JSW4.NET, Internet Hosting Services for Small Business.