Milimo Munyati
|
| Posted: 11/08/2002, 7:15 AM |
|
I have some table called reference_db, which has fields (section,sys_code,description). This primary key for this table is the combination of section and sys_code. The problem I have is that I need to display the description in the listbox.
Normally in sql (using Oracle DB), the statement I would use is
'Select description from reference_db where section='P033';
The reference_db contains alot of data for referencing purposes. For instances I keep information on banks, employee grades, gender in the table. The distingushing factor is using the section and sys_code fields. In other words banks, employee grades would have different section number and each bank and employee grade would have a different section code.
Now, I need to do something like this in the Lookup sql section and so far I am failing to display anything except 'All'.
Would anyone know how I can proceed??
|
|
|
 |
Ed Yin
|
| Posted: 11/12/2002, 2:14 AM |
|
not sure what u mean exactly, but if you want to display other fields sql works like this..
'Select whatever,description from reference_db where section='P033';
as i read when displaying for the listbox you need 2 fields.
this works for me
|
|
|
|
|
