🚀 go-pugleaf

I recently tried setting up a fairly simple database in Filemaker + to keep
track of an inventory.  I had number fields for each item to track and
summary fields to keep track of how many had been used total.  But, I
wanted to have it tell me how many items were left in the stockroom, so I
asked it to subtract the total from an original number.  It flat out
refused, and I got so irritated that it couldn't do this that I stopped
working on Filemaker + entirely for a while.  Essentially, I want to sum a
field for a number of records then subtract that sum from an original
value.  Doesn't sound that difficult to me.  Is there an easy way to do
this in Filemaker or can't it do it?  I think I can do the same thing in
Excel quite easily but Filemaker is so much nicer to use for data entry and
sorting.  Any ideas?
                            Thanks ...  Adam
-- 
Adam C. Engst					engst@tcgould.tn.cornell.edu
             					pv9y@cornella.bitnet
"If it's not interactive, it's not fun."