I have a table where i would like a column to input the totals into another field.
this field should then always equal to 0 or 100.
the mentality behind this is that each row entered will have a column for percentage of usage. if there were 4 rows added then each rows percentage should ultimately total 100. if there is no usage then this column would equal 0
hope that makes sense