Comparative list

[JimmyLewis]

Hi,

I am thinking of creating a db that will summarize the spending of my roommate and I in areas that we either need to split the bill (here percentages of splitting may apply) or a loan one to each other.

Eventually what i want to deduce from this whole deal is how much we owe one another and keep track of our mutual expenses when they are both of ours.

I already have a db with all my financial transactions. I was wondering what the best way to set this up would be, i.e. fields, tables, etc. and how i would go about deducing the info i want to see out of it.

Any help is appreciated.

Regards,

Jimmy