Learn about new technologies! 
How can you link a table with another so that a field in current table will display values in drop down box from another table while entering data:
Query Wizard
Look up Wizard
Form Wizard
Report Wizard