Lookup List of Values depending on a previous lookup list
Hello, I'm completely new to Access so this might sound a little too newbee for you. Well, here it goes. I'm creating a simple database for a competition. Participants are awarded points every time they do a certain volunteer job. My fields are the ID primary key, Last Name, First Name, Volunteer Job, Participation, Date and Points Earned. The Volunteer Job Field is a list of look-up values that I just created.
The issue is that "participation" should be a list of values but they directly depend on the volunteer job. This is that for example if I scroll down the Volunteer Job option and I choose let's say: "Newspaper", I want the "Participation" field to automatically show another look-up list with "Wrote an article; provided a tip for an article; volunteered for one hour". And every time I choose a different Volunteer Job from the drop-down list I created, the "Participation" field should show the appropriate list of options depending on the Job I chose.
Any ideas would be very appreciated thanks.
P.D: I'm not that much into SQL, so if the solution is typing commands in the row source property please help me out.