General information
Category:
Coding, syntax & commands
>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only