1 Reply Latest reply on Jul 15, 2010 1:05 PM by philmodjunk

    Get lookup value from most recent record, not first recrod

    ShawnAmann

      Title

      Get lookup value from most recent record, not first recrod

      Post

      Hello All.

      I am entering inventory (defined by Unique barcode and Lot#)

      When the user enters the barcode, I want the lot# to auto enter to save time (they can change it if not correct). A lookup really doesnt do it as the Lot# from the most recent record is probably the right one and Lookups seem to only pull from the first matching records (and if used for a long time this would bring up a lot number long out of use)

      Any ideas? Does this have to be done in a calcualtion or a script instead?

      Many Thanks