AnsweredAssumed Answered

Get lookup value from most recent record, not first recrod

Question asked by ShawnAmann on Jul 15, 2010
Latest reply on Jul 15, 2010 by philmodjunk

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

Outcomes