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?