AnsweredAssumed Answered

Script to pull / look up a reference value from an unrelated table

Question asked by annr on Dec 7, 2016
Latest reply on Dec 8, 2016 by djc728

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:

     TaxYear

     FilingDate

 

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!

Outcomes