Help With Cascading Combo Boxes

Losartan

Registered User.
Local time
Today, 00:16
Joined
Jul 21, 2005
Messages
39
I need some help setting up my tables to allow cascading combo boxes. I need to document when a Pharmacy IV room and chemotherapy room are cleaned. Each Room requires different cleaning procedures.

Here is my table structure:
TblCleaningDuties
DutyID-Auto# (PK)
Duty - text (Example- mop floor, clean hood, wash ceiling, wash sink)
Frequency-text

TblLocation
LocationID- Auto# (PK)
Location - Text (Clean Room, Chemo Room, Anteroom)

TblCleaning
CleanID-Auto# (PK)
LocationID-(FK)
DutyID- (FK)
Date/Time
TechID


If the user selects Clean Room I don't want them to see wash sink and anything else not pertinent to the Clean Room. How do I set up the tables?
Thanks,
Jason
 
Last edited:
There are many examples of how to set up Cascading Combo's including a demo in the sample forum. Have a search around

Col
 

Users who are viewing this thread

Back
Top Bottom