Most recent record
Is it possible to create a field which shows the most recent (previous) record for that field.
If I have a table showing production records, including the equipment used to run the product.
Product 1 ----- 10000 ran ----- Using Equipment 1
And I run Product 1 next month, can I have a field showing I used Equipment 1 last time it ran?