AnsweredAssumed Answered

Register banc movements

Question asked by Socio.t on Jun 25, 2009
Latest reply on Jun 29, 2009 by TSGal

Title

Register banc movements

Post

Hello everyone,

 

I'm tryng to make a database for my home budget management.

 

The idea I got was to make a table to the different kind of documents I usually have and then have all this to register in a central table, having them to increase or reduce my budget.

 

I thought I will have supplier invoices, like water and electricity that I can easily identify the supplier and have these regular movements. Then I will have current expenses that should work.

 

My point is that I don't know how connet this tables into the movement tables since they don't have a direct relationship.

 

Is there a way to automatically register values is the central "movement table" everytime I insert a register in the "invoice table" or "current expense table"?

 

I'm burning my brain over this. Maybe I got to complicated on something simple.

 

Thanks a lot for the help.

 

Best regards,

 

Socio

Outcomes