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?