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