Home » Developer & Programmer » Forms » dynamic form according to rows in another table
dynamic form according to rows in another table [message #480937] Thu, 28 October 2010 04:52 Go to next message
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 Go to previous messageGo to next message
cookiemonster
Messages: 13938
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 Go to previous message
Littlefoot
Messages: 21818
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/

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 04:48:47 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.