[belajar-access] Delete Record Master

Sebelumnya saya ada tabel relasi sederhana sepert ini:

tb_buku tb_peminjaman
|----------| |*id_peminjaman |
|*nm_buku |------>| nm_buku |
| jml | | tgl |
| | | jumlah |
|----------| |---------------|

Contoh data:
tabel tb_buku
----------------------
| nm_buku | jml |
----------------------
| buku1 | 5 |
| buku2 | 10 |
| buku3 | 2 |
-----------------------

tabel tb_peminjaman

---------------------------------------------------
| id_peminjaman | nm_buku | tgl | jumlah |
---------------------------------------------------
| PJ01 | buku1 |5/3/2011| 2 |
| PJ02 | buku1 |7/3/2011| 1 |
| PJ03 | buku3 |7/3/2011| 2 |
---------------------------------------------------
*Data baru ditambahkan k tb_peminjaman ketika button Simpan di klik

Agar suatu ketika saya ingin menghapus data di tabel tb_buku (buku1), namun data relasinya yang di tabel tb_peminjaman tetap ada untuk dijadikan histori, solusinya bagaimana ya? Sy hanya pakai Enforce Referential Integrity, tanpa cascade.

Terima Kasih atas pencerahan master2 access.

------------------------------------

SPAM IS PROHIBITEDYahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/belajar-access/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/belajar-access/join
(Yahoo! ID required)

<*> To change settings via email:
belajar-access-digest@yahoogroups.com
belajar-access-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
belajar-access-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/