Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Need help with my Program
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00134231
Message ID:
00134259
Views:
7
>Hello,
>
>I am creating a program using Visual Foxpro 5.0 for my work and need some help.
>
>What I have is 4 fields : "Name" , "Address" , "City-State-Zip" , and "Customer P.O. Number" ...
>
>What I want to do is , if I enter a name in the "Name" field and that
>name already exists , I want it to automatically fill in the "address","city-state-zip",and "customer P.O. number".
>
>The way I want it do this is , let's say I enter a name , I want a
>screen to pop up , with the 4 fields verifing this is the person if it is , I want to hit ok , well say , and for those fields to be filled in.
>
>If someone could help me out with this , I would REALLY appreciate it.
>
>I will give credit to your name for help with the program.
>
>Thanks and please Email me.
>
>Charles Simmons

I'll give this a shot, but it may not be the best way...

In the VALID of the name textbox:
lnRecno = RECNO()

IF Seek(this.value)
DO FORM verify WITH table.name, table.csz, table.po TO answer.
ENDIF

IF answer = .T.
SCATTER MEMVAR
GO lnRecno
GATHER MEMVAR

Ok, it's not real well thought out, but maybe it'll give you a nudge... :)

-Michelle
Previous
Reply
Map
View

Click here to load this message in the networking platform