OraFAQ Forum: Forms » displaying multiple rows retured from a query

Home » Developer & Programmer » Forms » displaying multiple rows retured from a query (oracle forms,6i,xp)

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

displaying multiple rows retured from a query [message #342720]

Sun, 24 August 2008 11:11

yoonus.it@gmail.com
Messages: 109
Registered: June 2007
Location: kuwait

Senior Member

I have two tables EMP_HEAD,EMP_TIME_Sheet. on this one i have created a master detail relation. When a user enters an head_id i want to select all employeed under him from enother table called employees and display in the emp_time.name item.

I am fetching values from another table that doesnt have a master detail relation with this table.

if only one emplyee is there under the head i know i can just use select statment with and display value on emp_time_sheet.name. It will return more than one employee ids.

Looking forward to your supporting

Thank YOu Smile