This is making me crazy--feels like it should be dead simple and I'm missing a basic concept.
I have a reference table with two fields:
I have a script where I want to use Year (EventDate) to look up the TaxYear column, and set a variable to the FilingDate value.
Similar to how you might pull a product name from a code, or city from Zip. Should I just add a calculated field which sets the EventDate Year, and set a relationship between the tables? Seems like there should be a more elegant approach without the surplus field.
Thanks again for your help. I'm looking forward to when I can start giving back on this forum!