AnsweredAssumed Answered

Lookup data based on dates...

Question asked by productionQC on Jul 28, 2014
Latest reply on Jul 28, 2014 by philmodjunk


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...?