| Dynamic LOV problem [message #466667] |
Tue, 20 July 2010 08:31  |
dhanasurya
Messages: 33
Registered: May 2010
|
Member |
|
|
Hi,
I have one requirement.I am populating LOV dynamically for the subinventory field in the order form through custom.pll.
If Dropship flag= 'Y' then populate suninv LOV with D1,d2..values.If it is 'N' then
populate suninv LOV with w01,w02,....values.This is done and working fine in the form.But
If i save dropship flag='Y' and Subinv value is D1 then it saves the record.Now I am changing Drop ship flag as 'N' then
'D1' value appearing in the SUBINV field.and it allow the save changes.
So How can i refresh Lov at the time of making drop ship flag as 'Y'/'N'?
Please give me the reply.
Thanks in Advance,
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Dynamic LOV problem [message #466682 is a reply to message #466677] |
Tue, 20 July 2010 09:26  |
cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
Explain the issue more clearly.
What was the value of subinv and dropship and at the start.
What did you change dropship to.
What happened to subinv.
What do you want to happen.
|
|
|
|
| Re: Dynamic LOV problem [message #466707 is a reply to message #466667] |
Tue, 20 July 2010 12:54 |
dude4084
Messages: 222
Registered: March 2005
Location: Mux
|
Senior Member |
|
|
What i perceived that you are getting problem is data consistency.
You need a value in Suninv =D1/D2/... when Flag='Y'
and value in Suninv=W1/W2/... when Flag='N'
I suggest you to use when_validate_item on Flag.
Validate Suninv with respect to Flag values. If validation fails then call LOV by using the command "show_lov"
This will solve your problem.
Good Luck
-Dude
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
