Record tranfer problem- VFP6- SOS

[DuffyW]

I've just implemented a program at a clinic and there's a minor glitch in the syntax I can't hammer out-<br>
<br>
I have two forms, one for patient referrals, and one for the main bulk of the data for regular patients.<br>
I have a button that's supposed to transfer the data from the referral form (which has it's own table) into the main form's table. Unfortunatley, it's not working correctly and I can't get the syntax to work- I want it to work so that the record shown on the referral form is the one transferred into the main table, and my syntax isn't working right- it keeps viewing the man table as an alias (the button is on the &quot;referral&quot; form) Any help is GREATLY appreciated- it's an SOS. my E-mail is <A HREF="mailto:chocklit@intrstar.net">chocklit@intrstar.net</A> Thanks! -Duffy <p>-Duffy W.,<br><a href=mailto:chocklit@intrstar.net>chocklit@intrstar.net</a><br><a href= > </a><br>

 

[ramani]

1. I assume that you have the master record in the referel form which needs to be located in the first form.
2. I also assume that these forms are having their own private data environment (since you are not able to get the values passed)

Solution could be to do the form2 from form1 to a variable and 'seek' that or 'locate' that in form1.

from form1...

DO form2 to lcForm1Variable
seek lcForm1Variable

Hope this solves the problem. If need more specific help, please post again or ask me.. since I do this type of search and seek in many of my form seemlesly and I have built my own incremetal search class with facility to filter.. search.. incremental search.. find.. etc and it works fine with almost all my applications.