2 combo boxes and displaying records for data entry

[shanewa]

On my form I have one combo box which shows a list of 5 years and another showing a list of people. What I would like to achieve is that after the year has been selected, the combo box showing the names only displays those employees which fall into the selected year. The record for that YEAR and that EMPLOYEE would be displayed and ready for data entry of 8 test scores. The employees names are pretty much static with the years going forward from 2002. Year and employees are seperate tables and I am not sure how to combine them. If I have 73 employees with a possible 5 years that could mean 365 records which could shrink or grow depending on staff movement.

Any help on this would be gratefully received

Many thanks in advance.

 

[Jack Cowley]

The article below should answer your question...

http://support.microsoft.com/support/kb/articles/Q209/5/76.ASP?LN=EN-US&SD=gn&FR=0&qry=q209576&rnk=1&src=DHCS_MSPSS_gn_SRCH&SPR=ACC2000

 

[shanewa]

Thank you for the article but I cannot change the tables as they are coming from a as/400. any other suggestions?

 

[David R]

Jack's suggestion doesn't modify the tables, it creates linked combo boxes. Wasn't that your question?

You can unify data from disparate tables into one query if you want to see data from both, as long as there is a linking field of some sort.