lookup column with selective values

[techexpressinc]

I have a table where I want a selection of dates from another table to be in a drop down box. I am not sure how to do it. It is a simple db at this time.
table1 = activitytable with fields: personname, trainingname, dateoftraining
table2 = trainingdates with fields: trainingname, trainingdate, misc
table3 = trainingname with fields: trainingname (only)

When someone enters data into the activitytable we need a drop down for the dateoftraining with only the dates display associated with the field (activitytable:trainingname) I am thinking a query would be need against table2 trainingdates to show only the field trainingdate where activitytable:trainingname = trainingdates:trainingdate

Could someone point me in the right direction. Thanks
Russ at TechExpressInc.com

 

[Remou]

Have a look at this faq702-4289.

 

[techexpressinc]

Thanks Remou I will take a look. Russ