>>Again, thanks for your reply.
>>I have since checked your SQL - as I expected, it worked correctly.
>>
>>I think that using views may not be right & creating my own SQL & using forms is a good way to go. It might mean a little extra work, but it will mean I have better control over what is going on (I have a background in control systems where safety is critical & am vary wary of automatically produced code).
>>
>>While writing the last paragraph, I re-read the documentation & found the possiblity of creating the view myself (CREATE SQL VIEW) - that may give me the best of creating my own SQL with any benefits of views.
>
>Yes, you can create your own views. I never did it; it seems you have to set quite a few properties. If you need it, I am sure somebody else can help out.
>
>>Again, thanks for your time, it was very helpful
>>Irene
>
>I am glad to be of help.

Thanks for you comments about this & clarifying SPT before I got around to looking further. I've had chance to play with SQL more today & have decided to use SQL with forms & forget about views.
Irene