How to send some data from 3 tables to another one;

[diobab]

Hi to all ,
I am running a project , and i have this problem.
I have 3 tables for example t1 (recID , Name , 1trID , 1banID , date , amm , 1logID) where recID is primary key ,
next table is t2 (recID , Name , 2trID , 2banID , date , amm , 2logID) and here the primary key is recID ,
and the last is t3 (recID , Name , 3trID, 3banID , date , amm , 3logID) with recID as primary key.
I want to create a new table as example ttotal. In this table i want to register some data from t1 , t2 , t3.
When i put a new record in t1 i want to send the fields name, 1trID , 1banID , date , amm , 1logID.
The same fields from a record of t2 and the same fields from t3.
When i delete a record from t1,t2 or t3 , the record must be delete from tTotal table.
I want to concentration the specify fields from t1,t2,t3 to tTotal.
How can i do that.

Any ideas.


Thanks
Dionisios

[June7]

That structure does not appear normalized. Why not one table instead of three? Have another field for the t1, t2, t3 category.

Saving calculated data (data based on other data) is usually a bad idea. Synchronizing the 'total' data with raw detail data is a headache, as you are finding out. Instead of a table for totals, calculate this data when needed.

Why delete records?

[diobab]

Table t1 has payments information on staff, table t2 has the same information for drivers and table t3 the same information about payments to suppliers. This works very well until now. What interests me is to watch bank accounts. For example, how much money has paid a bank account, what the balance is. I tried to get the information with query but did not succeed. I thought to collect records of arrays t1,t2,t3 to a table ttotal and then query to find what I want. Even you may need to erase a payment, it should be wiped from the table total. If you got a better idea would appreciate it.

[June7]

Why was query not successful?

A payment is still a payment. You describe these tables with the same fields. This tells me should be one table.

Should be able to manipulate data with queries to get the desired output. Basically the same manipulation would have to be done to get the data saved to 'totals' table. Just use queries and the output will be dynamic. Queries can be built from other queries. Delete raw data record, the query will automatically adjust.

What is involved in deleting a payment? Is a check voided? To maintain accountability, don't think I would delete.

I just don't understand the data structure. Maybe simple join query is good enough. Maybe need a UNION. Resorting to UNION query is another indication data is not properly normalized. If you want to provide db for analysis, follow instructions at bottom of my post.

Are you familiar with off-the-shelf accounting software? I have used Quickbooks which is relatively inexpensive and easy to learn and use.