three combo boxes

I am in a process of developing a database, but I need to ask many questions
before I get started and then find out that certain functions won't work will
be frustrating so here goes my question. Let's say I have a Form that is
consisted of many combo boxes and I want particulary 3 combos to synchronize.
For example, I have set up three tables (tblBeginningStatus, tblGrade, and
tblSecondarySchool); so if I select Beginning status field, I want Grade
field to populate based on values of the Beginning status, and when I select
secondary school, I want that to populate values from the Grade field. Is
this mission possible or impossible? Please anyone if you can help I would
highly appreciate it.....

See this website for information on how to "cascade" combo boxes:
http://www.mvps.org/access/forms/frm0028.htm


--

Ken Snell
MS ACCESS MVP
http://www.accessmvp.com/KDSnell/


"Mani" wrote in message
...
I am in a process of developing a database, but I need to ask many
questions
before I get started and then find out that certain functions won't work
will
be frustrating so here goes my question. Let's say I have a Form that is
consisted of many combo boxes and I want particulary 3 combos to
synchronize.
For example, I have set up three tables (tblBeginningStatus, tblGrade, and
tblSecondarySchool); so if I select Beginning status field, I want Grade
field to populate based on values of the Beginning status, and when I
select
secondary school, I want that to populate values from the Grade field. Is
this mission possible or impossible? Please anyone if you can help I would
highly appreciate it.....