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 !