plz suggest me

sourav123

Hi,
Can anybody help me that when i m trying to total a field some error occure.

i hav a 2 field 1 is total qnty and another is qnty

item no || type || total qnty || qnty ||
001 || aaaa || 7 || 4
001 || bbb || 7 || 2
001 || ccc || 7 || 1

i want to add qnty to check wheather it is < or = to total qnty but it should not more then total qnty . it is summing the qnty properly but when the sum became > total qnty then error throws as expected from code and the summing stoped.from now that is OKK. but the problem is after receiving the error i could not even change the previous record to a smaller num. but it should b change as bcoz the qnty < total qnty..
can anybody suggest me d code.

j.marselo

you do not need codes. you only need a flowfield in the table. use flowfield for total qty.

garak

First : Your Subject is not "the" best.
Second : How looks your source and where and what are you doing?