Oracle Forms 4.5 question

Hi,
I am using Forms 4.5 and Oracle 7.
What I am trying to do here is:

Using combo box to populate the database. The table that I am referencing :

SELECT * FROM CRED_CODE;   CRED_CODE CRED_DESC

• -------------------- 5 Excellent 4 Good 3 Average 2 Below Average 1 Bad

Therefore, in my form, It will list available data ( ie Excelent,Good,Average etc)
ie: Let say I chose Excellent it will populate 5 in the database table. However, I do not want to Hardcode the list Element. What I want to do is to populate the List Element with Select statement. So that when I add more data in the cred_code table, ie : INSERT INTO CRED_CODE ( CRED_CODE, CRED_DESC)

     VALUES ( 6,'Very Excellent');
I do not need to change the List Element. Instead it will automatically populated
using the select statement.

Thank you for your help

Assoy

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Jul 13 1999 - 01:21:34 CDT