|
I have made real simple databases before. This one is more into it
then the ones I have done before. I want to choose a task from a
combo box, and then have it choose from that selection which table to
pull the descriptions from for the next combo box.
Example tables:
Work Done - Main Table
Tasks: Drains, Gas, Water (Is in a table of it's on)
Task Descriptions: Drains Descriptions, Gas Descriptions, Water
Descriptions (Each of these are in there own table)
So, there are 5 tables, while working in the main table, be able to
choose the task in the combo box from the task table. While still in
the main table after choosing the task have that task choose which
description table to choose from for the next combo box.
Let's say I choose water in the first combo box, and in the next combo
box I would want to choose a Description from the water description
table.
Is something like this possible? If so, how would you go about doing
it?
Thank you in advance for your help.
Patrick
| 
