Get lookup value from most recent record, not first recrod
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?