I have a form based on a tblStudy on this form in the header area is a combo box where user can select the Study. Then Each study will have more then one section (1 to M) and Each one of this section would have more then one Folder (1 to M) and Each Folder will have more then one DocumentInfo (1 to M).
Now what I would like to do is I want user to select “Study” from combo box and then select “section” for it from combo box and based on “section” selection a list of Folder is listed in a subform in the detail section. Then based on selection of “Folder” there will be another subform for “DocumentInfo”
What is the best way of doing this ? Any example would be helpful.