>Hello Barry.
>
>
>I have a combobox (dropdownlist style) on a form which holds a key field from a parent table (say, order numbers). On the same form I have a grid which holds the child table. Both tables are in the DEnvironment and are related via the appropriate field (OrderNo). When I select a value in the combo I expect the grid to change to show only the order details relevant to the selected order. However, this does not happen.
>
>
>The easiest way to implement this sort of thing is to create a parameterized view for the child table. Then, all you need is this code in the Valid of your combo (where vp_value is the view parameter:
>
>vp_value = This.Value
>REQUERY( 'MyView' )
>Thisform.Refresh()

Hi Marcia,

yes, I found I could make it work using a view. But I was curious to know why my logic (or lack of) did not work with the base parent and child tables. But maybe curiosity is a luxury I can ill afford?! Just accept that the view works and get on with it....

Regards
Barry.