Cascade one combobox to two more

[pivottable]

Hi,

I'm trying to understand if making a selection in one combo box can filter two further combo boxes at the same time.

The scenario is recording the types of labour a patient may undergo. The options are:

1. Spontaneous
2. Induced
3. None (Caesarean before labour)

If Spontaneous, there are two options for Intervention. None, one or both options can be selected:

1. ARM
2. Oxytocin

If Induced, 4 options for Intervention One to four options can be selected:

1. PG
2. ARM
3. Oxytocin
4. Mechanical

If Induced, the user must select an Indication for Induction.

tblDeliveries keeps a record of all deliveries
tblLabourType: types of labour
jtblLabIntervention: junction table because Intervention to Labour Type is many to many relationship
tblIntervention: the different interventions possible for Spontaneous and Induced labours
tblIndicationIOL: indications for Induced Labour.

Based on help from experts on this forum, I have created a cascading combo box so that indications for induced labour can only be entered if type of labour = induced.

Can I also use the type of labour combo box to cascade to the interventions subform, to allow the relevant options for Spontaneous and Induced?