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" <Mani.TakeThisOut@discussions.microsoft.com> wrote in message
news:FCD38F2C-4B1F-4787-AFD7-AC6784584ACF@microsoft.com...
>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.....