I'd like to do something quite challenging (in my view) with web2py. I have a table (products), where each product has one or more codes. The list of possible codes are stored in a separate table (codes), and a third table (product_codes) stores the relationship(s) between the product and the code(s).
I'd like a form that allows the user, on creating a new product, to choose one or more codes for the product. I assume this would be using checkboxes, pre-populated from the codes table. Upon submission, two tables are affected: the new product goes into the product table, and one or more records into the product_codes table. Is this possible? Is it possible using CRUD or SQLFORM? I'm at a loss as to how to start this. Thank you for your help, in advance.
