Gossamer Forum
Home : Products : DBMan SQL : Discussion :

easy relational data question

Quote Reply
easy relational data question
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.
Subject Author Views Date
Thread easy relational data question newbe101 2272 Jul 29, 2006, 3:14 PM
Thread Re: [newbe101] easy relational data question
newbe101 2152 Jul 29, 2006, 5:38 PM
Post Re: [newbe101] easy relational data question
newbe101 2133 Jul 30, 2006, 6:02 PM