Hi Barbara !

Thanks but it is not such simple, relation in shown view window and display status are OK.

When I made simplier form (only with grid) and set relation in the same way, all is OK. When I use sales form that is much more complicated it doesn'work.
It should work because when I work with view I use the same alias name so

>The first thing I would do is make sure you didn't accidentally set the relation from the table when you meant to set it from the view. If you DISP STAT after setting the relation, does it show the relation is from the view?
>
>If the relation is from the view, the next thing I would do is check the contents of the CustId field in the view. If they're all the same, there's some error in your join condition of the view.
>
>>Hi All !
>>
>>I have a form with a grid (sales grid). One column of the grid has control source from related table (custonmer.name). When grid recordsource is table (sales) all is OK, but when grid recordsource is view ( vMonthSales) the grid column display name of first customer in all rows. In both cases is used the same command "set relation to custid into customers"
>>Any suggestion. Thanks in advance !