Hi all,
I have 3 tables: product, supplier and po. Each product belongs to a supplier. I use the po table to create purchase orders. I set up the po add_form with a dropdown select which is populated with the suppliers. The add_success forwards you to the modify_form to add the products to the po. I have setup 10 items to add to the po. What I need help with is creating dropdown selects for the 10 items that are populated with the products that are owned by the supplier. I used <%Dbsql::Relation::HTML::generate_full_down('product', 'supplier')%>, but it contains all of the products, not just the particular suppliers products.
Please help. Thanks.
I have 3 tables: product, supplier and po. Each product belongs to a supplier. I use the po table to create purchase orders. I set up the po add_form with a dropdown select which is populated with the suppliers. The add_success forwards you to the modify_form to add the products to the po. I have setup 10 items to add to the po. What I need help with is creating dropdown selects for the 10 items that are populated with the products that are owned by the supplier. I used <%Dbsql::Relation::HTML::generate_full_down('product', 'supplier')%>, but it contains all of the products, not just the particular suppliers products.
Please help. Thanks.
easy relational data question