7 Replies Latest reply on Feb 28, 2016 12:10 PM by mkenglen

    Need help creating a relationship against a range of dates


      Good Morning.

      I have two tables that I'm trying to create related field for:

      one that manages events that employees travel to. It contains their event start date and the mileage to the event.

      the other table contains IRS mileage reimbursement data for a particular date rang (i.e. from 1/1/15 to 6/30/15).

      I'm having trouble figuring out how to relate the two so that: if the event start date falls within a certain date range in the IRS Mileage table, I could then bring over the IRS mileage figure that relates to the event start date.


      Can someone point me in the right direction?


      Mary Kay