AnsweredAssumed Answered

AutoFill depending on value in range

Question asked by JasonHyde on Sep 15, 2010
Latest reply on Sep 15, 2010 by philmodjunk


AutoFill depending on value in range



I am struggling with creating an autofill type field based on another fields value. I'll explain.

I enter a date in to field1, I also have records that have this structure:

Range1 - Start Date, End Date

Range2 - Start Date, End Date

So if my date entered is within Range1 I would like field2 to autofill to Range1's Label. Each range is unique and does not overlap, so there is no conflict. It's a tracking problem - I need to know where something is depending on the date it was created.

Anyone suggest a solution?