I am developing a HR database in access 2007

I've got a primary table of worker info and many tables that report to that particular table ( education for instance) that list the acceptable elements that may populate that cell for the reason that row

After i produce a form it had been produced as only a plain text area that is restricted however i wanted to produce a dropdown which had only the data that they're permitted to go in to prevent confusion.

You need to have the ability to right-click on the text box and choose Switch To -> Combo Box.

If you're not acquainted with creating controls, it is advisable to make use of the magicians. Choose a combobox in the toolbox and combine it with your form, you'll be led through creating the kind of combo that you would like.

It's also wise to examine the associations you've produced.