Limit options corresponding to previous choice

[Keeperen]

Hey,

Still working on my first db.

I have attached the db.
I have two tables where TBL_Underaktiviteter (tbl_sub) is a subtable to TBL_Hovedaktiviteter (tbl_main) - meaning that if you choose the value 200 in tbl_main I can limit the possible outcome of tbl_sub. So fare so good.

In tbl_Underark_aftaleseddel I want to use the limited input from the 2 other tbls, but if I choose the value 200 in the column Hovedaktiviteter I can still pick all the values in the column Underaktiviteter.
How do I limit the selectable values in the the column Underaktiviteter when I have selected a specific value in Hovedaktiviteter ?

In advance thanks.

 

[MarkK]

This is called a cascade. Search for 'cascading combos' since this is most commonly implemented using ComboBoxes
Cheers,
Mark