>>>>>>>>>>>>>>>>>>>
>I tried relating the view directly to the reference table instead of relating the base table to the reference table, but it did no better.
>>>>>>>>>>>>>>>>>>>
>
>That should've worked. Get both of them opened, each one in a browse from the command box and see that the child from the relation cycles properly when you move in the parent (table or view).

Alex,

As you know, I am migrating and app from FPD. What happened was that in the form load I changed a SELECT BaseTable to SELECT TheView and as a result I unintendedly placed a filter on the view! So all the logic fell apart.

Thanks for your response.

Alex