Ronel Cabrera - 2011-07-01

per product category i have certain field. Lets just say i can sum up all the balances in the orderline in every category. For example in my orderline i have chicken breast ($15),chicken wings($10), beef ribs($25) and tuna fish($20), having a product category of chicken, beef and fish. In my orderline i have a summary saying that in Chicken - $25 beef - 25$ and fish - $20.. my problem is that whenever i add a new category i have to create column in the database. It's kind of a long process, is there another way where i can do this? or maybe still do all the process but using only a push of a button or using validators?

Help. Thanks.