|
F
|
frocco 8/29/2006 |
|
I would load a session variable using the before edit event and then modify the lookup table to use the where clause to filter the badges table. Hi! I don't understand how to get the lookup wizard to filter using the WHERE. Here is what I want to do... I have a table of scouts and their age. I have a table of merit badges and their minimum age allowed. I have a registration table where I add merit badges for scouts. There is a drop down field for the badge name built from the badge table. This all works fine, but now I need to filter the list of badges in the drop down based upon the scouts age and the minimum age for a badge. Could someone PLEASE point me in the right direction??? thanks! Joe D. |
|
|
D
|
debiso author 8/30/2006 |
|
I'm not really sure how to do that. How do I reference the variables in the code? Hi! I don't understand how to get the lookup wizard to filter using the WHERE. Here is what I want to do... I have a table of scouts and their age. I have a table of merit badges and their minimum age allowed. I have a registration table where I add merit badges for scouts. There is a drop down field for the badge name built from the badge table. This all works fine, but now I need to filter the list of badges in the drop down based upon the scouts age and the minimum age for a badge. Could someone PLEASE point me in the right direction??? thanks! Joe D. |
|
|
J
|
Jane 8/31/2006 |
|
Joe, |
|
|
D
|
debiso author 8/31/2006 |
|
In that example the field I want to test is in the current table. I need the master table for the current. Joe, you can do it using depending dropdown boxes on the ADD page. Select Lookup Wizard for the ScoutsAge field, choose Lookup table option and set all required settings. Then select Lookup wizard for the MeritBadges field, check off This dropdown is dependent on option and set all requored settings. Also you can see "How to setup dependent dropdown boxes on Edit/Add pages" flash tutorial here: http://www.xlinesoft.com/phprunner/php-database.htm |
|