Cascading Combobox question

[pivottable]

Hi all,

I'm trying to use a cascading combo box to filter the options that can be entered into a second combo box.

In frmBabies, a Mode of Delivery is selected from 8 options. 4 of these are "normal" deliveries and 4 are caesarean sections.

A second combo box selects the Indication for Operative Delivery. The table tblIndOpDel contains options for normal as well as caesareans. I would like to filter the indications so that the user cannot enter an indication for normal delivery for a caesarean section.

Both tblIndOpDel and tblDelMode have a foreign key to tblDelModeCat, which categorises deliveries as normal or caesarean.

I'm stuck on how to proceed from here. Sample database attached.

Thanks in advance!

 

[Uncle Gizmo]

I've done a YouTube on it HERE:-

Cascading Combo Box 1

http://youtu.be/Bm-NNqBFahI

 

[pivottable]

I've done a YouTube on it HERE:-

Cascading Combo Box 1

http://youtu.be/Bm-NNqBFahI

That's Awesome!!

Thank you Uncle Gizmo!!