Posted by heyvinay on 10/01/53 11:41

I have transaction table where the rows entered into the transaction
can come a result of changes that take place if four different tables.
So the situation is as follows:

Transaction Table
-TranId
-Calc Amount

Table 1 (the amount is inserted into the transaction table)
- Tb1Id
- Tb1Amt

Table 2 (an amount is calculated based on the percentage and inserted
into the transaction table)
-Tbl2Id
-Tb2Percentage

Table 3 (the amount is inserted into the transaction table)
-Tbl3Id
-Tbl3Amut

Table 4 (an amount is calculated based on the percentage and inserted
into the transaction table. )
-Tbl2Id
-Tb2Percentage

How do I create referential integrity between the Transaction table and
the rest of the tables. When I make changes to the values in Table 1 -
4, I need to be able to reflect this in the Transaction table.

Thanks.

• Next in forum: Re: Referential Integrity - linking multiple tables to transaction table
• Prev in forum: 1 day left: 75% discount on SQL Server/Oracle/MySQL/Firebird/InterBase developer tool!
• Thread view: Referential Integrity - linking multiple tables to transaction table

[Reply to this message]