Relational Databases.

[Snide]

I am creating a db for a trouble call system. I am going to have the user
select their department via a lookup table from a combo box (I am limited to
only 6 departments). Then when the user selects the department a second
combo box selects a division from said department, each department will have
their own table with a list of divisions within. There will be
approximately one table of divisions for each department. Now here is what
I need these tables to do. The department that is selected triggers only
the divisions within that department, I don't want to see any other division
from another department.

How can I do this? Thanks.

Snide

 

[Duane Hookom]

You should have only one table for divisions, not separate tables based on
department. There is a sample of "cascading combo boxes" at Roger Carlson's
web site of small sample databases
http://www.rogersaccesslibrary.com/TableOfContents2k.asp