Hey Guys,

Need help in my inventory program.

The situation is like this:

I have a table (TABLE 1) which contains fields (item (c), s40(n), s20(n)) how can I get the records in TABLE 1 particularly fields item and either of s40 or s20 which ever i selected then append all of them into lets say TABLE 2 and at the same time get total of either s40 or s20.

example: (TABLE 1)
________________________________
Item s40 s20
--------------------------------
paper 3 2
bottle 12 25
_______________________________
15 27

(TABLE 2)

_______________________________
s40 15
-------------------------------
s20 27