>Hi Kamil,
>
>Probably, you have the second (supplementary) table mentioned in Tables property. Try to remove it from the Tables list.
>
>Thanks,
>Aleksey.
Hi, Aleksey.
If i remove it from the Tables list i will not be able to create a join, will i?
Anyway.
I didn't have time to answer my own post.
I compared closely those two almost identical views, and what i found was one small difference - the view that works has "Fetch memo" and "Include memo fields in WHERE clause" boxes ticked while the same boxes in the erronous view are not.
There are no memo fields in both of the base tables.
Well, you never know...
PS I feel i have a perfect right to award myself with the three stars.
Best wishes.
Kamil.
A moment of silence is our cosmic reset button.