I have 2 combo box. the first one the parent and the other one is the child. I would like to filter the child combo box when i selected the parent combo box.
Here is my table structure:
parent
id,description
child
id,description, parent_id
i have embed point on takenewselection of parent combo with the following code:
FDCB::View:FileDropCombo{PROP:SQLFilter} = 'parent_id = ’ & parent_table:Id
But its not working.
Thanks