New User help! Drop Down list - tables?

[TimJames]

I am making an inventory database to keep track of keys. So far my stumbling
block is a table of departments that employees belong to. My departments are
arranged thusly:
Department Sections belong to Departments that belong to Divisions.
So I made three tables that refer to each other and you make your selection
via drop downs. What I would like, however, is when you are filling out the
employee table / form you would pick out the Division and depending on what
you select, your choices for departments are limited to what belongs to that
particular division. And then the same situation for Department Sections.

I am new at Access, so am I barking up the wrong tree or do I need to look
at this totally differently?

 

[Dirk Goldgar]

(re-sending, as my original reply hasn't appeared)

I am making an inventory database to keep track of keys. So far my
stumbling
block is a table of departments that employees belong to. My departments
are
arranged thusly:
Department Sections belong to Departments that belong to Divisions.
So I made three tables that refer to each other and you make your
selection
via drop downs. What I would like, however, is when you are filling out
the
employee table / form you would pick out the Division and depending on
what
you select, your choices for departments are limited to what belongs to
that
particular division. And then the same situation for Department Sections.

I am new at Access, so am I barking up the wrong tree or do I need to look
at this totally differently?

This is a common feature, often referred to as "cascading combo boxes".
This page describes two basic ways to implement it:

http://www.mvps.org/access/forms/frm0028.htm
Forms: Limit content of combo/list boxes

 

[Steve]

Hi Tim,

You are describing "Cascading Comboboxes". Go to www.mvps.org/access for an
example of how to set up cascading comboboxes.

Steve

 

[TimJames]

I am looking at these answers and trying - but I am scratching my head an
awful lot! But I wanted to thank everyone so far!

Go ahead and continue to post more replies if you would like.

Thanks - Tim

 

[Steve]

Your question comes up frequently in the newsgroups. Try a Google search at:
Groups.Google.com

Steve