OraFAQ Forum: Forms » where i past query for move deptname to textbox

Home » Developer & Programmer » Forms » where i past query for move deptname to textbox

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

where i past query for move deptname to textbox [message #654676]

Tue, 09 August 2016 05:54

mfahimaamirgmailcom
Messages: 64
Registered: May 2011
Location: pakistan

Member

sir i use master detail form with lov

when change record how move department to textbox in form
that get by query the deptno change auto by master detail relationship but how change department name to detail block text box

select depname into :detail.deptname form depttable where deptid=:detail.deptid

where i past this query in block envent

Report message to a moderator

Re: where i past query for move deptname to textbox [message #654733 is a reply to message #654676]

Thu, 11 August 2016 06:36

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Instead of posting a bunch of fuzzy questions in a few minutes that no one will make the effort to understanding as you made any effort to write them, I advise you to take the time to think and write the questions in a clear way so that even your mother can understand them.

Report message to a moderator

Re: where i past query for move deptname to textbox [message #654735 is a reply to message #654733]

Thu, 11 August 2016 07:27

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Why do you need department name in the detail block? As you said, this is a master-detail form. Department number as well as department name are displayed in the master block. All that detail block needs is the department number (which should be invisible anyway), while department name doesn't have to exist in the detail block at all.

Report message to a moderator

Previous Topic:	Order by record value
Next Topic:	ora-40737 in go

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 23 07:37:15 CST 2025