In Ride_Data table, you should add a field name "Weather_ID".
You create a relationship between table Ride_Data and table Weather using fields Weather_ID = Icon_ID
Your weather value list should be on field Icon_ID from table weather + second field IconName. Displaying only the second field if wanted.
Then on the layout, you add the field Weather_ID from table Ride_Data, which should be a drop down list based on your value list. This will fill in the weather_id field and activate the relationship.
Next to your drop down list, you add field Icon from table Weather.