🚀 go-pugleaf

In article <1993Jan11.203119.10597@Newbridge.COM> jeffl@Newbridge.COM (Jeff Laks - qmail) writes:
>In our db, we have defined one of the fields as an auto-entry field for 
>the modification date.  So, everytime I change the data in a record, the 
>date will change to reflect this.  The problem arises when we do a 
>'relookup' - we have two dbs linked, and if you do a relookup, it obviously 
>does a comparison search on every single record and therefore updates the 
>modification date for every single record! 


Jeff,
     
    Add a serial number field to your database and tell your script to find
the current recor before you issue your relookup command.   Then do a Find All 
to get back to all your records.

Here's the script: 
 

Copy                Serial_Number
  Select entire contents     
 
Enter Find Mode
 
Paste               Serial_Number
  Select Entire Contents

Relookup
  Perform Without Dialog

Find All


     Oh, one other thing.  You have to put the serial number field in the 
layout that you'll be doing the search from.  I set mine to a 1 point yellow
typeface (yellow doesn't show on the B/W monitors) and make it non-printing, 
delete it from the tab order, and push it off the right side of the screen.
This makes it more-or-less invisible to the user.

Mike Gordon  N9LOI  mwgordon@nyx.cs.du.edu