Check Sergey's solution first. I think it will give you the result you wanted.
Anyway, I appreciate a more descriptive definition of the problem.
Thanks.
>Good evening Naomi,
>
>I do it now...
>
>>>It looks like you always have just one record per iID and iTraiterID in Agenda, e.g. iID is unique and iTraiterID is unique. Scratch my code then. I need to think a bit more.
>>>
>>
>>Ok, after thinking a bit more I now don't understand what are the requirements. If iID in Agenda is unique and iTraiterID is unique, when based on what you're going to update Agenda?
>>
>>Can you please start a new thread and put the test data and the result that you want to achieve?
If it's not broken, fix it until it is.
My Blog