Jumping from file to file?

[Nancy Palmquist]

Henry,

To do this you have two choices with popup update

You can create the records in the other files with lookup file r=free 
and then use popup update file screen to enter data directly.  This 
method does not allow the use of any @when processing on the fields in 
the other file.  If the file is simple, say adding a code to a list 
where no @when is necessary, this is fine.

If the record you are adding requires @when leaving rules to make it 
work nice, then you need to draw the data into dummy fields, make a 
screen in the current file with those dummies displayed, then use popup 
update - SCREEN to handle the data entry.  When entry is done, post the 
data back to the record in the other file.

Once you do this a bit the flow is easy.  I like to wait until they save 
the dummies to create a new record, especially if you give them a chance 
to change their mind and not write it after all.  It makes it cleaner.

Don't forget on an update to lock the record when you draw in the data 
and then unlock it when you write your changes back, to avoid someone 
changing it at the same time.

Hope that helps.
Nancy

On 4/2/2015 8:46 AM, melancon at cajun.net wrote:
> Thanks, Scott.  I appreciate the help.  I use the lookup command for a
> number of things.  I was wondering if there may exist a Filepro command
> that would make this easier.
>
> Henry
>
>
>
>
>> Use of the "system" command would allow you to accomplish this but or it
>> might be better controlled with a series of lookups of a free record in
>> those files and then doing a popup update
>>
>>> -----Original Message-----
>>> From: Filepro-list [mailto:filepro-list-
>>> bounces+scottwalker=ramsystemscorp.com at lists.celestial.com] On Behalf Of
>>> melancon at cajun.net
>>> Sent: Wednesday, April 01, 2015 5:00 PM
>>> To: filepro-list at lists.celestial.com
>>> Subject: Jumping from file to file?
>>>
>>> Window Server
>>> FilePro 5.0.14DN9
>>>
>>> I have three FilePro files named Roll, Can and Mill.  Is there a command
>>> that will allow me in processing "when leaving a field" to jump from one
>>> file to another file to a certain screen and field?
>>>
>>> I would like to input information into the Roll file, save it to a
>>> record
>>> and then jump to Scree "2" in the Can file to enter more data and save.
>>> The last stop would be to jump to Screen "2" of the Mill file, save and
>>> then jump back to the Roll file.
>>>
>>> Is this possible?
>>>
>>> Thanks,
>>>
>>> Henry W. Melancon
>>> Gulf Island, LLC
>>>
>>>
>>> _______________________________________________
>>> Filepro-list mailing list
>>> Filepro-list at lists.celestial.com
>>> Subscribe/Unsubscribe/Subscription Changes
>>> http://mailman.celestial.com/mailman/listinfo/filepro-list
>>
>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>

-- 
Nancy Palmquist         MOS & filePro Training Available
Virtual Software Systems    Web Based Training and Consulting
PHONE: (412) 835-9417           Web site:  http://www.vss3.com