one form or many

[pedro8ae]

Hi friends, I am developing a project for an department in a school.
this school has some other sub-campus and each campus has different
rooms. ex.:
School XY:
sub-Campus 1:-> Room1.1, Room 1.2, Room 1.3, Room 1.4, Room 1.4
sub-Campus 2:-> Room2.1, Room2.2
sub-Campus 3:-> Room3.1

I want to create a form that allow the user to select a sub-campus and
then automatically
the form shows the respective room for that campus. Ex.:
In a drop box: sub-campus 1
In another list box: will show the rooms for that specific campus.

Do I have to create for each sub-campus a table?
how can I design a form like this..
I want the result of this selection be saved in a table.

If someone gets this message, please write me back......
Thank you...

 

[Guest]

To do this correctly, you need two tables, Campus and Room. The Room table
needs the Campus table's primary key as a field that will be the Foreign key.

Then your form should be a form and sub form. The form should be based on
the Campus table and the sub form on the Room table. When you do this
correctly, each time you change campus, the Room records for that campus show
in the sub form.