Adding another table

[sir_dan_mitchell]

Hey guys,

I have a created a system wherby it calculates money going in and out of the business. Is it possible to add another table and then use this table for just entering extra costs to the business like stationary etc?

Currently I have members, socials and Arrangements tables. The Extra costs table works ok, but I dont know what to relate it to as when I try to calculate using it, it will bring up too many records (i.e. not being unique).

I have current Outgoings for socials and I want to add them to Extra outgoings to create a total outgoings, but I cant seem to figure it out.

Any ideas guys?

Dan

 

[Rich]

You should just have one table and another field which defines the expense