Adding Records Using a Combobox 2

[phishfn]

This should be simple enough but it's stumped me.

I have a simple data entry form of user information (name, address, phone number, city, state) that open after someone clicks a "New Employee" button. Currently to add a new employee, you just type in the information in the textboxes and close the form and the new info is added to the employee info table.

For consistency I wanted to add 2 comboboxes to the form for City and State so the user entering the new employee info can just pick those 2 from the list instead of having to type them in every time. What's the best way to go about this?

Thank you very much (c:

 

[docmeizie]

Once you have changed those controls to combo boxes you have to create a query that gets just the City and one that gets just the State. hmmmmmm..... It would be better to create tables for the City and State and populate them with the appropriate data then set the relationship like so

City ---> User <--- State

Arrowheads are the many side of the relationship.

If I take a peek in your Windows, to fix a problem, does that make me a &quot;Peeping Tom&quot;? Hmmmmmmmmmm

 

[phishfn]

Cool, thanks for the resopnse. I'll give it a try and let you know how it goes (c: