OraFAQ Forum: Forms » display field not populating

Home » Developer & Programmer » Forms » display field not populating

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

display field not populating [message #221448]

Mon, 26 February 2007 18:25

sophia_786
Messages: 13
Registered: February 2007
Location: manchester

Junior Member

Hi all,

i have a problem in populating a display field in forms 6i.

i have the columns and tables as follows..

employee table
emp_id(pk)
dept_id(fk)

dept table
dept_id(pk)
dept_name

i have a from displaying the employee details, i have created an lov to select a dept_id for a given employee which works fine.

in this lov the dept_id is shown aswell as the dept_name.

the dept_name goes into a display field under the same block.

this populates fine. however when this record is saved and i select enter query...execute query the dept_id is shown but the dept_name display field is blank.

im guessin i have to create a trigger but unsure which one...

thanks in advance

Report message to a moderator