
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 14, 2021 02:41 PM
Hello!
I’m looking for a way to restrict a lookup to only the record with the max date in a date field.
Context: Managing a vehicle fleet
Bases:
-
Registration
-
VIN
Desired outcome
Only display the license plate that is associated with the registration record that has the max “license plate exp date” value.
I’m not sure how to go about this. Seems like there may be a way to do so by
- creating a view in the registration base that only shows the records with the most recent
- restricting the lookup to that view
but can’t figure out the first step there.
Any help appreciated.
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 14, 2021 02:48 PM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 14, 2021 02:48 PM
See this thread, but do the latest date instead of earliest date:
