>i'm a girl come from hk, quite fresh in develop the system by using vfp, i'd like a favour from u , thx.
>
>1. a form contains two combo, they call combo1 and combo2
>2. the dataenv contains 2 local view one for search category no, another for search the product id.
>3. user has to choose one category for the product in combo1
>4. depends on the category number, the specified product id will all be listed out in combo2
>
>Meanwhile, i dunno how to solve the technical problems in retrieving data using which event(s). And also dunno how to list the data after requery in the local view into the combo.
You should requery("secondview") in combo1.interactivechange event to get all product ids for selected category number. After this you should issue (in the same event) combo2.requery to get new view content to the combo list portion.
Edward Pikman
Independent Consultant