limiting a look-up column based on current row data

[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

 

[Alansidman]

Look at this site and focus in on the combo box presentations

http://www.datapigtechnologies.com/AccessMain.htm

Alan

 

[techexpressinc]

Thanks for the pointer a "combo box" i need. Russ

 

[techexpressinc]

Re: limiting a look-up column current row data - datasheet view

Would this be possible in datasheet view?
Thanks Russ