AnsweredAssumed Answered

Lookup data based on dates...

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

Title

Lookup data based on dates...

Post

     Hello, 

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

      

     Thanks

      

Outcomes