>Hello,
>
>I am working on these 2 tables. There is parent and child relation. Before I allow user to save the record I need to do validation on the field in the child table(sum the total points for all the records with same id). Because the both tables are bouffered it does not see the current value. Can someone help with that.
>sherry

If you would use p-view, then you may either count in view (buffer) by using CALCULATE, or count in base table by using SELECT-SQL.