1 Reply Latest reply on Jul 28, 2014 4:23 PM by philmodjunk

    Lookup data based on dates...



      Lookup data based on dates...



           I have a well established database with a table called "tests".  I have just imported two years worth of weather data into a table called weather.  What I want is to have it so that when a user is on a record in "tests" it pulls that days weather from the the table "weather".  Both tables have date fields.  What's the best way to go about this...?