Linking values in combo boxes

[Haynesey]

Hi,

I have a form (frmMaster) with three fields in that are all combo boxes. Depending on what I select from the first box (Function) needs to determine which values can be selected in the second combo box (Activity) and then depending on which I select from the the second box will determine which I can select from the third combo box (Transaction).

I have tried to link the fields in another lookup table called tlkpTemplates but think I am getting confused.

I have attached a copy in case anybody has any ideas.

Many thanks in adavance, I am just going round in circles.

Cheers

Lee

 

[DCrake]

You need to be searching for Cascading Combos. There are many topics on this subject here.

David