So the position in the RELATIONSHIP is: "Refer the attachment"

"Context of Approval", "table cross", "Type of Approval", "table cross", "Risk", "table cross", "Risk Category"

Im not very familiar with access + just a basic knowledge of codes. Right now the way Im doing:

The way I make the form, main form is the Risk Category,...

The first combo box is called CBO_CONTEXT, second CBO_APPROVAL and third CBO_CATEGORY. CBO_CONTEXT combo box has several data represent as mother grouping for CBO_APPROVAL, selecting a particular CONTEXT, should filter APPROVAL belonging only from the CONTEXT selected. Selecting a particular APPROVAL from the CBO_APPROVAL combo box filters the CATEGORY combo box.

Then there are subform below will produce a data (data inside table Risk)...

Hi

I am designing my first database. I'm trying to create cascading combo boxes in a form and display the data inside the subform. I have 3 combo boxes on the form. I'm trying to make them dependent on each other so by selecting one combo box updates the others in the series.

Diagrammaticall y the model is:

1. Context of Approval----<Type of Approval----<Risk Category
2. Produce data inside...