Hi! :)

Is there any way for a computed field to derive its value from other
dataset?
I'm thinking of something like :
...
alter table master
add DetailCount integer computed by
(select count(*) from detail where (master.masterid =
detail.masterid))
...

The above query doesn't work...:)

Thanks in advance,
sugi.