I've got a bunch of small, light, high value items for sale. I'd like to record the actual weight (not the shipping weight) in my inventory record and use that info to total up the weight of a purchase of multiple items.
I thought that a User Field would help, but I think I'm trying to force it into something it wasn't intended for. The text fields aren't much use--can't total them. The non-text fields are Currency. At the moment, I just know that when the value is $5.00, that means it's 5 ounces. Not very satisfactory, and I still don't see any facility to do arithmetic on them.
So now I have even more problems. I need a solution to my actual weight problem. Explaining to me that I'm going at it all wrong will count as a solution.
The other problem: What use are the User Fields? Why are some of them Currency? They could just as well all be Text, as far as I can see.
Ned
|