>Hi Gang,
>I'm almost there. I have two tables, one client the other payment. I relate the tables by Client.ss_numb to Payment.ssnumber
>what I'm trying to do is collect data from a form that has two text fields (textbox1, textbox2). I'd like to use these these text box's
>to collect data to v mem ver. Then collect the ver's and relate then to fields in one table (payment.group_code, payment.ins_co_name)
>have the results go into a cursor, then set the order to Client.last_name. And last but not least, select the cursor,
>then print my report payment3
>
>Can anyone please help I'm down to the wire with this one.
>Please Help
>John
Add a command button to run the query. In the command.click:
SELECT * FROM Client ;
WHERE ss_numb = txtssn.value ;
ORDER BY Last_Name INTO CURSOR cClient
SELECT * FROM Payment ;
WHERE ss_numb = txtssn.value ;
INTO CURSOR cPayment
SELECT cPayment
INDEX ON ss_numb TAG ss_numb
SELECT Client
SET RELATION TO ss_numb INTO cPayment
Now, having done that, you should know that ssnumber is NOT a good key. There are duplicate ss numbers. You can't guarantee it will be correct.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer