Cascading Combo Prob & Unique Value for each Record

[bennybee]

I have made my cascading combo box, and it works well.
i have it running in a subform. where the user selects a subject within the sub form and the associated actions related to that subject are displayed in another combo box.

however, i cant make it store the value that i select for the record.

for instance.
i select "Liquor" as the subject, and "Approve Liquor App" as the action.
then for the next record i select
"Tobacco" as the subject and then "Cancel the Licence" as the action.

however it changed the entry made for the Liquor entry, so now it reads

Liquor - Cancel the Licence
Tobacco - Cancel the Licence.

how do i make each record store the value that is selected for it stay, and not change everytime a new action is selected?

 

[Mile-O]

It sounds like you have not linked the Master & Child Fields between the main form and the subform.