James,
If you have learn about 'Normalisasi',
you can find about 'Referential Integrity' terms. You cannot delete a
record in master table if you have a history record in transaction
table. You can mark a record in master table as 'Not Used' (create a
flag field named 'CustomerFlagStatus', an example).
Muhammad Rivai Andargini
----- Original Message -----
From: "James Azarja" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Thursday, July 28, 2005 9:34
PM
Subject: [Programmer-VB] Delete data
master
> dalam tabel kustomer), enaknya itu diapain, apa langsung dibuang, atau
> dimasukin ke tabel lain. Soalnya kalo transaksi penjualan ada kode
> kustomernya aja kan kalo recordnya udah dibuang gak bakal bisa dijoin
> buat dapetin nama kustomernya.
>
> Mohon solusinya :)
>
Untuk keluar dari millis ini, kirim email kosong ke:
[EMAIL PROTECTED]
YAHOO! GROUPS LINKS
- Visit your group "Programmer-VB" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
