Home » Developer & Programmer » Forms » display field not populating
icon7.gif  display field not populating [message #221448] Mon, 26 February 2007 18:25 Go to next message
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

Re: display field not populating [message #221464 is a reply to message #221448] Mon, 26 February 2007 23:36 Go to previous message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
POST-QUERY.
Previous Topic: ORA-00918: column ambiguously defined
Next Topic: How to use a button with a required field
Goto Forum:
  


Current Time: Sun Dec 11 06:13:45 CST 2016

Total time taken to generate the page: 0.07234 seconds