>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.
If it's not broken, fix it until it is.
My Blog