OraFAQ Forum: Forms » LOV Problem

Home » Developer & Programmer » Forms » LOV Problem

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

LOV Problem [message #182251]

Fri, 14 July 2006 00:14

qadeerahmed
Messages: 63
Registered: July 2006
Location: Pakistan

Member

Hi,

I've a scenario as:-

In LOV i've list of 7 Subjects, and i've 7 Text Fields.
I want to do as, When User Calls LOV from First Text Field, and the Selections Was Made at that time, Should not be listed in LOV, Whenever He Calls LOV from next Field.

e.g,
If I Call LOV From Field 1 and Select subject Say as ' Distributed Computing', and then whenever I call lov from Field2 then ' Distributing Computing' Should be not listed in LOV.

Hope so you got my point....

Waiting For your Reply
Thanks

Report message to a moderator

Re: LOV Problem [message #182261 is a reply to message #182251]

Fri, 14 July 2006 00:51

Maaher
Messages: 7065
Registered: December 2001

Senior Member

You can add a where clause to the record group:

where yourcode not in (:block.field1,...,block.field7)

MHE

Report message to a moderator

Re: LOV Problem [message #182315 is a reply to message #182261]

Fri, 14 July 2006 05:31

qadeerahmed
Messages: 63
Registered: July 2006
Location: Pakistan

Member

Maheer,
I didn't understand this, 'yourcode'
what is 'yourcode' means here ????

Thanks !!

Report message to a moderator

Re: LOV Problem [message #182318 is a reply to message #182315]

Fri, 14 July 2006 05:38

Maaher
Messages: 7065
Registered: December 2001

Senior Member

You want to filter out the values that already exist on the form. This value comes from a database column - wild guess - and I have called that database column 'yourcode'.

MHE

Report message to a moderator

Re: LOV Problem [message #182409 is a reply to message #182318]

Fri, 14 July 2006 11:18

qadeerahmed
Messages: 63
Registered: July 2006
Location: Pakistan

Member

Thanks Maheer !!
Now Its Working Nicely.

Thanks Again.

Report message to a moderator

Previous Topic:	inserting data to a word file
Next Topic:	Requests submitted from form cannot be found

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 10:48:07 CDT 2024