OraFAQ Forum: Forms » dynamic form according to rows in another table

Home » Developer & Programmer » Forms » dynamic form according to rows in another table

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

dynamic form according to rows in another table [message #480937]

Thu, 28 October 2010 04:52

narang79
Messages: 137
Registered: June 2010

Senior Member

sir

i want to create a form & show some
columns accordingly rows entered in another table

for eg.

a table name temp have three columns (no,name,date)
in name it shows some rows like
a
b
c
d

i want to create a new dummy form which shows
a b c d

if i remove b from temp table then new form shows only
a c d

is it possible

Report message to a moderator

Re: dynamic form according to rows in another table [message #480938 is a reply to message #480937]

Thu, 28 October 2010 04:56

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

Well you could create an item for each column in the table and then write some code in the WHEN-NEW-FORM-INSTANCE trigger to check the table and the set the visible property of each item that isn't in the table to false.

Report message to a moderator

Re: dynamic form according to rows in another table [message #480939 is a reply to message #480938]

Thu, 28 October 2010 05:10

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

Senior Member
Account Moderator

You might try to create a default form (use wizard); then go to data block's property palette and set Record Orientation to "Horizontal". Block's WHERE clause should be "where name <> 'b'". Execute query; this is the result:

/forum/fa/8377/0/

Attachment: forms_horizontal.PNG
(Size: 2.13KB, Downloaded 922 times)

Report message to a moderator

Previous Topic:	No. Of Checkbox clicked at a time
Next Topic:	host comman on linux

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 09 10:23:33 CST 2025