>Can Someone please offer some insight??
>
>In my search for the ever changing correct way to do things..
>
>The Over-Simplified Vesrion:
>
>If I have a combo-box (Referred to as comStates) that contains the Names of States of the USA and this Combo-Box's Control Source is thisform.cState_Name
>
>My Second Combo Box would Contain the users of that state based upon
>the Value of the first combobox. I would do a SQL Statement in the Rowsource of the 2nd comboBox that said something like...
>
>Select * from States where st_Name=thisform.comStates.Value into Cursor comNames
>
>Of course, this will Puke... I was wondering how a more 'Seasoned' approach to this would be??
>
>Thanx Much!!!
>Bob :-)
At 1st combobox InteractiveChangeEvent issue the following:
Thisform.cState_name = This.Value
Thisform.2ndCombox.Requery()
Your 2nd ComboBox should have the following SQL:
SELECT states.username, st_name FROM states WHERE states.st_name = Thisform.cState_name INTO cursor ComNames
For Correct DisplayValue of the 2nd Combobox, the Bound Property should be set to 2 instead of 1 which is the default.
JESS S. BANAGA
Project Leader - SDD division
...shifting from VFP to C#.Net
CHARISMA simply means: "Be more concerned about making others feel good about themselves than you are in making them feel good about you."