Arsip: Bagaimana cara Lookup Field Tabel
more 16 years ago
ari_volker
aku ada masalah lagi nih,,
Gini,,
Kana ada tabel 2 tabel
misal namanya :
1. Tabel User
2. Tabel Alamat
ceritanya mau nambah field pada tabel " User "
Tapi Field tersebut hasil dari Lookup Field table Alamat,,
Ada yg tau caranya ga,,.
Thankzzz..
more 16 years ago
nurez
itu pakai inner join...
insert into table_user inner join table_alamat on table_user.user1= table_alamat.alamat1 where table_user.user1 is nuLL
atau bisa jg insert into table_user select user from table_alamat << iini kYnya ngopi seleuruh isi table,
klo ragu? tanya lagee... kesaalahan bukan terletak pada sY, tp terletak pada anda yg blm mencoba dn mencoba.. hehehe
more 16 years ago
rhendrawan
misalnya pake TADO table..
di click kanan dan proprtiesnya kan bisa bikin new Field
nah pada field type nya bisa pilih lookup..
selebihnya explore aja yah..
:)
more 16 years ago
ImanD
@ari_volker: ceritanya mau nambah field pada tabel " User " Tapi Field tersebut hasil dari Lookup Field table Alamat,,
@ari_volker: coNTOHin donk boz,, yg menggunkan wherebenar2 pertanyaan yg aneh, ini yg ditanyakan apakah create field pada table user dengan data dari table alamat atau hanya ingin menampilkan field <dengan lookup table atw dengan SQL>?!
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
- Komponen tidak terlihat dipalette
by rusli_chow in Tip n Trik Pemrograman more 16 years ago - MAHASISWA BARU alias ANGGOTA BARU
by aji_suprayogi in OOT more 15 years ago - Trigger Pakai Variabel dan Konstanta ?
by umarbakri in MySQL more 17 years ago - Form tidak tampil
by Arieska in Tip n Trik Pemrograman more 17 years ago - survey , mohon direspon.
by mat_koder in OOT more 16 years ago - Mengatur Print nota dan continous form dengan LX300/800
by fakhrudin in Hal umum tentang Pascal Indonesia more 15 years ago - Tanya SQL di Ms.Access??
by gold3n_b0y in Hal umum tentang Pascal Indonesia more 17 years ago - mysql sudah terinstall atau belum lewat delphi ??ask
by purnomo2007 in Hal umum tentang Pascal Indonesia more 14 years ago - operasi record
by thiena in Hal umum tentang Pascal Indonesia more 17 years ago - [ask]menampilkan data dari dua table dalam satu from
by kepiss in Form Enhancement & Graphical Controls more 12 years ago