J
Joe Cilinceon
I have several tables in a relationship and was wondering if you do a
Cascade Delete how it would work.
The table layout is like below:
TENANT.CustNo (to several other tables such as Address, Contacts etc.)
LEASES.LedgerID ( links to the LEDGER )
LEASES.CustNo ( links to the TENANT.CustNo )
LEASES.UnitNo ( links to the UNIT.UnitNo )
LEDGER.Transaction (1 record per transaction and links to both Payments and
Charges below)
PAYMENTS.Transaction (1 or more items with same transaction)
CHARGES.Transaction (same as payments)
If I want to delete a LEDGER.Transaction along with the related PAYMENT &
CHARGES but nothing else how to I setup these relationships. I played with
it a bit but also took out the Tenant and Lease info as well which I don't
want.
Cascade Delete how it would work.
The table layout is like below:
TENANT.CustNo (to several other tables such as Address, Contacts etc.)
LEASES.LedgerID ( links to the LEDGER )
LEASES.CustNo ( links to the TENANT.CustNo )
LEASES.UnitNo ( links to the UNIT.UnitNo )
LEDGER.Transaction (1 record per transaction and links to both Payments and
Charges below)
PAYMENTS.Transaction (1 or more items with same transaction)
CHARGES.Transaction (same as payments)
If I want to delete a LEDGER.Transaction along with the related PAYMENT &
CHARGES but nothing else how to I setup these relationships. I played with
it a bit but also took out the Tenant and Lease info as well which I don't
want.