Arsip: master-detail-subdetail pake 2 key
more 15 years ago
pwa
ceritanya gini.. saya bikin program penjualan toko cat yg melayani pembuatan formula, formula ini dibuat dari campuran banyak cat (tints).
untuk satu transkasi penjualan formula, data yang dicatat adalah sbb:
1. Data Penjualan
- NoNota
- Tanggal
- NoPelanggan
2. Detail Formula
- NoNota
- KodeFormula
3. SubDetail
- NoNota
- KodeFormula
- KodeTints
Maunya sih ditampilin semua master-detail-subdetail... Tapi kyknya tambah ga informatif.
Pertanyaan:
1. Gimana bentuk laporan yg cocok buat kasus d atas?
2. Untuk MasterDetail ke tabel SubDetail kan pake 2 key (NoNota, KodeFormula), cara pake di FastReport gimana?
Mohon pencerahannya....
Terima kasih,
Pwa
more 15 years ago
reminder2k1
mmmhhh... kayaknya agak ribet struktur tablenya... Tapi klo emang kebutuhannya spt itu mo di bilang apa lagi... xixixixixi...
Sekedar usul, bagaimana klo di buat jadi 2 table aja (master-detail)...
Nah strukturnya di rubah dikit aja:
. Data Penjualan
- NoNota
- Tanggal
- NoPelanggan
2. Detail Formula
- NoNota
- KodeFormula
- KodeTints
Klo design tablenya dah enak, percaya deh untuk buat reportnya pasti gampang banget... Apalagi menggunakan FastReport, tgl klak-klik selesai deh... :mrgreen:
more 15 years ago
pwa
hehe ada yang replay... trims :P
Alesan jadi 3 tabel karena data masternya juga dipecah..
Jadi kepatok sama itu deehh..
Sep2 ada pencerahan
Makasiiiiiiiiii buanyaaaakkkkk :D
more 15 years ago
khairul
Saya dulu pernah tanya ini, berikut saya berikan link thread yang sudah ada.
http://pascal-id.org/dpr/index.php?name=PNphpBB2&file=viewtopic&t=5550&highlight=
Semoga bermanfaat.
more ...
- Pages:
- 1
reply |
Report Obsolete
Last Articles
Last Topic
- PascalTalk #6: (Podcast) Kuliah IT di luar negeri, susah gak sih?
by LuriDarmawan in Tutorial & Community Project more 3 years ago - PascalTalk #5: UX: Research, Design and Engineer
by LuriDarmawan in Tutorial & Community Project more 3 years ago - PascalTalk #4: Obrolan Ringan Seputar IT
by LuriDarmawan in Tutorial & Community Project more 3 years ago - PascalTalk #2: Membuat Sendiri SMART HOME
by LuriDarmawan in Tutorial & Community Project more 3 years ago - PascalTalk #3: RADically Fast and Easy Mobile Apps Development with Delphi
by LuriDarmawan in Tutorial & Community Project more 3 years ago - PascalTalk #1: Pemanfaatan Artificial Intelligence di Masa Covid-19
by LuriDarmawan in Tutorial & Community Project more 3 years ago - Tempat Latihan Posting
by LuriDarmawan in OOT more 4 years ago - Archive
- Looping lagi...
by idhiel in Hal umum tentang Pascal Indonesia more 11 years ago - [ask] koneksi ke ODBC user Dsn saat runtime dengan ado
by halimanh in FireBird more 11 years ago - Validasi menggunakan data tanggal
by mas_kofa in Hal umum tentang Pascal Indonesia more 11 years ago
Random Topic
- Select Outer Join Dengan Bulan Skarang
by delphi1st in Tip n Trik Pemrograman more 17 years ago - Deteksi status Dual Monnitor komputer
by kabuki_enemy in Tip n Trik Pemrograman more 15 years ago - heLp mE pLease ?
by jajang in Tip n Trik Pemrograman more 15 years ago - Augmented reality
by LuriDarmawan in Multimedia & Graphic Enhancement more 13 years ago - Source code document generator
by cikumiyu in Hal umum tentang Pascal Indonesia more 16 years ago - blajar ZQuery
by luq_h in MySQL more 12 years ago - [ASK] MySQL Error Can't Create TCP/IP
by holmes in MySQL more 15 years ago - COMBOBOX baca SQL Gimana caranya..??
by D-Nai in MySQL more 17 years ago - [ASK] Versioning
by cyber_hecker in Tip n Trik Pemrograman more 16 years ago - Program Akses Flash Disk
by delphi1st in Tip n Trik Pemrograman more 17 years ago