Multiple Cascading Combos

[wordsmith]

Hi All,

I have a query about cascading and combo boxes, which I was kindly, advised about previously. However, I’m stuck as to how to cascade using the selections from more than one combo box. Here are the tables involved

tblLine
fld LineID (PK)
LineDesc

tblMachine
MachineID
MachineDesc

tblLine_Machine
LineMachineID (PK)
LineMachineDesc
LineID (FK)
MachineID (FK)

tblCategory
DTCategoryID (PK)
DTCategoryDesc

tblDTReason
DTReasonID (PK)
DTReasonDesc
tblCat_Mach_Reason
CatReasonID (PK)
DTCategoryID (FK)
MachineID (FK)
DTReasonID (FK)


What I’m trying to do is create a form to enter downtime incidences and would like the downtime reason to be selected following a series of combo boxes. The first combo box selects the Line on which the downtime has occurred, using this, the next combo box selects the machine. I would like the category selected independently but then need the Downtime Reason selected based on the selections in the machine combo box and the category combo box. This is where I am having the problem.

I can get the machine combo box to display machines dependent on the Line selected and I can get the downtime reasons combo box to display machines dependent on either the machine selected or the category selected, but I don’t know how to get it to do it based on both.

e.g. the category may be mechanical, but there are reasons that are mechanical and specific to each machine.

Any help with this would be most appreciated.

Regards

Keji

 

[Robert88]

Hi Wordsmith,

Try this link, Cascading Combo box notes;

http://www.fontstuff.com/access/acctut10.htm

You could also try searching the forum as there are heaps of examples on this.

Robert88

 

[wordsmith]

cheers for that! looking through it now.

Kind regards,

Keji