>Hi Nadya,
>
>Good to see you too :-) (Funny, I thought you would be the first person to reply to my first ever message on UT)
>
>Possibly triggers can do the job. I will look into that. But I thought about another approach, right after I posted my initial message. I am thinking about creating a view with a calculated field. I have never had a view with a calculated field on sum in another table so I don't know if it will work. I know by the end of the day I will know if it works.
>
>Thank you for your helpful suggestion.
>
>Dima
The idea is interesting, but I don't see, how it would work. Would appreciate it you let me know the result.
Also I thought a little bit about triggers idea. Insert and Delete triggers are trivial, but I'm not sure, how to implement Update. I believe, I saw a thread here while back on this topic, I'll try to find it.
Take care.
If it's not broken, fix it until it is.
My Blog