That's what I thought as well Mark. However, I started this and got stuck. I created a new table called "Year" and created a Numeric field of the same name. Then I created a record for each year starting with 2022 out to 2050 for now. But these are numbers not actual "Years", so when I went to make the report thinking could filter the list to only show records where the Year is during or after the current year, that wasn't an option because I wasn't using a date field. But date fields show more than just the year, so how do I produce just a list or records showing just the year to then use as the list for the drop down on the Parent record? I expect I am missing something simple.
------------------------------
Chris Swirtz
------------------------------
