[Rlambjr21]

Hello,
I'm working on a wardrobe database that selects my clothes. I have a form that asks for the season through a list the values are: spring, summer, winter, fall. When the user picks the value I want the program to pull one record from the shoes table, pants table, and the shirts table where the season field of each table is "the value of "season" in the form. I don't understand how to code this. Can anybody help?