I am at a loss for how to accomplish what I need. Currently I have created a table for names (20 records) and another table for fruit. (5 records) Each year every person gets to select 2 pieces of fruit from the list of 5) I have created a form with a subform that allows me to choose a name and make a selction (from a drop down of the fruit table) for that persons 2 choices of fruit. A 3rd table holding the choices [Fruit Selection) will then have 2 records per/person. However, I need to tie that down to 3 levels so that I first choose the person and then year (or vise versa) before making his selection. (Anotherwords, A form within a form within a form) I feel I may need a pass thru table to accomplish this but I am having trouble seeing the necessary relationships that will be needed.

Another way of looking at this is I need my [fruit selction table] to be dependent on two differnt tables (year & person).