Author Topic: lookup  (Read 824 times)

0 Members and 1 Guest are viewing this topic.

Gary

  • Member
  • Posts: 3
    • View Profile
lookup
« on: April 06, 2011, 10:17:52 AM »
I'm viewing a record in file 1. Using the @key command I would like to jump to a new record in another file
and at the same time have a program fill in some of the fields in the new record with info from file 1, and allow me the fill other fields in that record. It seems a system call might be the way to go, but I can't quite figure the correct procedure. Any Ideas?

Bill Randall

  • Administrator
  • Posts: 53
    • View Profile
    • http://www.fptech.net
Re: lookup
« Reply #1 on: April 07, 2011, 06:42:56 AM »
In the manual.  Refer to 'lookup dash'

   'lookup -' can move you to another record in the current file
Bill Randall

Gary

  • Member
  • Posts: 3
    • View Profile
Re: lookup
« Reply #2 on: April 07, 2011, 10:23:05 AM »
Bill, I want to jump to another file. If I understand Lookup- correctly it will take you to another record in the file you're presently in.

Bill Randall

  • Administrator
  • Posts: 53
    • View Profile
    • http://www.fptech.net
Re: lookup
« Reply #3 on: April 07, 2011, 10:31:37 AM »
You do either but you may just be better do a regular lookup.  You can just do a lookup to the file you want if you know the record or free if you are adding and then do a POPUP UPDATE on that record.
Bill Randall

Gary

  • Member
  • Posts: 3
    • View Profile
Re: lookup
« Reply #4 on: April 07, 2011, 03:29:06 PM »
That works great. My next question is....why didn't I think of that?