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
Lost the plot
Hi Guy's
This is probably an easy question! But here goes.
I want to run a LostFocus event to populate the fields on a form with data held in two different tables for a value already entered in a box on the form.
I've created an SQL statement to get the data I need but I can't quite figure out how to populate the rest of the boxes on the form with it.
Hope that makes sense!
David
ROTVAL = THISFORM.txtnrotno.VALUE
SELECT S_MOIM01.M_reqnum,S_MOIM01.M_ponum,S_MOIM01.M_sname,S_MOIM01.M_rotat1,;
S_MOIM01.M_dategrw,S_MOIM01.M_invdescr,S_MOIM01.M_item_nos,;
S_MOIM01.M_qtygrw,S_MOIM01.M_wtgwr,S_MOIM01.M_partcomp,;
S_MOIM01.M_sup_refr,S_COIM01.Ce_pono,S_COIM01.F301,S_COIM01.F302,;
S_COIM01.F303,S_COIM01.F304,S_COIM01.F305,S_COIM01.F306, S_COIM01.F307,;
S_COIM01.F308, S_COIM01.F309, S_COIM01.F310, S_COIM01.F311,;
S_COIM01.F312, S_COIM01.F313, S_COIM01.F314, S_COIM01.F315,;
S_COIM01.F316, S_COIM01.F317;
FROM K:\SSS\S90\S-MOIM01.DBF S_MOIM01 INNER JOIN K:\SSS\S90\S-COIM01.DBF S_COIM01 ON S_MOIM01.M_reqnum = S_COIM01.CE_REQNUM;
WHERE (S_MOIM01.M_rotat1=ROTVAL)
1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11:
Solution
About this Solution
Sign up Now to View This Solution- Zone
- general
- Tags
- FoxPro
- Participating Experts
- 2
- Solution Grade
- A
Posted on 2009-10-16 at 04:40:10ID: 26270611
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.