[AccessD] Combo to Combo

Virginia:
You need a many-to-many table to relate the Systems to the Failure Types ...

tblSystem:
PK=systemID
1 (Alarm)
2 (Dryer)

tblFailType:
PK=FailTypeID
1 (Age)
2 (Wear)

tblSystemFailType:
FK1=SystemID	FK2=FailTypeID
Alarm  		Wear
Alarm			Shorted
Dryer			Wear
Dryer			Age


Then on the form, after user selects system from combo1, requery combo 2 to
show the applicable  failure types

Combo 2 source = "SELECT FailTypeID, FailType FROM tblFailType WHERE
FailTypeID IN " & _ 
" (SELECT FailTypeID FROM tblSystemFailType WHERE SystemID=" & me.combo1 &
")"

Hth

Steve




-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Hollis, Virginia
Sent: Friday, September 30, 2005 2:27 PM
To: accessD at databaseadvisors.com
Subject: [AccessD] Combo to Combo

I need to create a combo box that lists system identifications. When the
selection is made from the system combo, the 2nd combo only lists related
failures. The problem is the System and the Failure are repeated. An Alarm
can have the same type of failure as a Dryer.

 

How do I set up the tables & the form for the combos to list the Systems
with the matching Failure types when they are all repeated?

 

Example:

System, Failure

Alarm, Age

Alarm, Normal Wear

Alarm, Corrosion

Battery, Overload

Battery, Age

Dryer, Normal Wear

Dryer, Age

Dryer, Obstruction

 

Virginia

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com