First off, I hope to help others in the future on this site...not just have issues!
I created a database where I needed to add fields to get the total in another field- field 1 + field 2 = Totals Field (not exact names of fields)
I did this in the form which was the only way to get it to...
On the second part about seperate tables- I had that and a person who was helping me told me to get rid of the extra tables. I do have more categories, but wanted to keep it simple for purposes of the forum