How to automate three consecutive in a form.?

[assala]

Hello programmers...

I am desiging a simple access system to display the city name, universities in that city and majors in the chosen university ..

for example:
[city_id] [Uni_Name] [Majors]
KL ---------- UM ------------ EEE, EET,EM,IT
KL ------------ UPM------------ EM, MBA, CE
JB ------------ UTM ------------ MBA, IT
...
..
.
etc


I want to design a form start with a city name, when the city is chosen, only the univeristy name displays the uni in that city and the only the majors
available in that uni is displayed when it comes to major selection..

I want to know how to design the tables , and how to auto populate them .

this may sound a stupid Q .. but for me i am really stuck ..
first time to come across auto populate fields..

thank you very much ...
appreciate your help ..

 

[Uncle Gizmo]

What do you mean by auto populate the tables?

 

[assala]

well...

in a form, when you choose a city, only names of universities in that city appears..it is like auto fill..

 

[Uncle Gizmo]

Do you want this list in a combo box?

 

[assala]

amm.. I guess it will be necessary to have a combo box unless there is other way ..