bas60
Posts: 18
|
| Posted: 04/10/2011, 2:28 PM |
|
I'm using a modified book store example ...
I have placed a droplist from category_id - filled from store_category
and this works fine... ie. only selected category is displayed
I have now added a 2nd droplist product_id but I need this to be filled from store_products but only select items where the category is the selected category above.
I think I need to do this via SQL but I just can;t seem to get the right SQL
I've tried:
select * from store_products where category_id = s_category_id order by product_name
but its not right !
Any help appreciated
|
 |
 |
damian
Posts: 838
|
| Posted: 04/10/2011, 3:00 PM |
|
use dependent listbox tool from toolbox
_________________
if you found this post useful take the time to help someone else.... :)
|
|
|
|
|
