>Hi Naomi,
>
>Thanks very much for your code. Key fields, etc. specified, I now get an error I was getting in the earlier phases - "The key defined by the key field property for the table is not unique" and "Update Conflict". This means that in the past 2 days I have gone a full cirle. Tried every permutation and combination to do something, which I believe should be a breeze, but no results. Help! ...and thanks once again.
>
>Regards,
>
>Steve.

Please post your view definition. I think the problem is in using distinct clause. Also can you use just one table for your view? Let's start from something simple and then make it more complex.