Updating a file while in another file

[John Esak]

You don't really want to use SYSTEM for this. You _should_ use POPUP UPDATE
to change/add/modify the data in that record in the other file. You can do
all the "input" processing you want on the that record from where you are
standing. To do this just accomplish the input processing with @wlf type
processing form the processing table in which you are standing. Design the
POPUP UPDATE screen to look just like the screen in the other file, but use
dummy variable instead of the real fields.  You can then use @wlfaa (or
such) to process whatever you need... then when the user presses SAVE to
store the POPUP just write all the fields in the other file with their
associated dummies....  lookup(1)=aa; lookup (14)=jc, etc. Works just fine
and gives you maximum flexibility.

John Esak

  -----Original Message-----
  From: filepro-list-bounces at lists.celestial.com
[mailto:filepro-list-bounces at lists.celestial.com]On Behalf Of Vicky Prigg
  Sent: Wednesday, April 28, 2004 3:26 PM
  To: filepro-list at lists.celestial.com
  Subject: Updating a file while in another file



  I would like to, while in one file, open up a new record in another file
and be able to post data to it and then update the new record with the rest
of the data that I need.  Right now, I am using lookup to a free record and
posting the data over.  I used a SYSTEM command to take me to the screen in
the other file.  I can't use POPUP UPDATE because I need some input
processing to take place in the lookup file.  My problem is, I can't tell
the SYSTEM command to go into that record that I just created from the
lookup.  The SYSTEM command just takes me to index selection using the -xi
flag.  I can't even use a saved selection set because the value of the field
changes with every record.



  Vicky Prigg

  Laparkan Trading Ltd.

  2929 NW 73rd St.

  Miami, FL 33147