Access this solution immediately by signing up as a member of FoxproAnswers.com--it’s quick, easy, and secure. We will return you to this solution, unlocked, when you’re done.
Question
Can't populate a Visual Foxpro combo list.
I know this has to be something stupid I'm doing. I have a table called Products that contains a list of "Machines", for each machine there are a number of "Stations". I'm trying to make a form where the user selects a Machine from a list, then based on which machine they choose, when they click on a second field, a combo list appears and only the stations for the machine they've picked are listed. The product table contains multiple rows with the same Machine, but each Machine/Station combination is unique. I've tried adding a procedure with a SQL statement but I can't get the second list to populate.
LPARAMETERS lall
IF lall
SELECT DIST station as stationa,* from products into cursor station READWRITE
ELSE
SELECT station as stationa,* from products WHERE ;
ALLTRIM(STR(products.machine))=ALLTRIM(thisform.machine1.combo1.displayvalue) ;
into cursor station READWRITE
ENDIF
1: 2: 3: 4: 5: 6: 7: 8:
Solution
About this Solution
Sign up Now to View This Solution- Zone
- general
- Tags
- Combo List SQL Statement
- Participating Experts
- 1
- Solution Grade
- A
Posted on 2009-01-12 at 08:07:12ID: 26222399
All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.