We're creating a sign up list for our fortnightly inductions at work. We've got a list which has all the induction dates, and another list for the signups.
The signups list has a lookup field to the date column of the induction date list. This then enables us to display the list of signups for the induction on the dispform of the particular induction date.
What I'd like to do is get SharePoint to automatically not display past induction dates in the lookup field. I was hopeing there would be something similar to how in views you can filter by date being > [today]
I know we could just delete past dates manually, but I'd like to remove human error as much as possible.