| Poplist issue [message #426297] |
Wed, 14 October 2009 15:32  |
abum
Messages: 1
Registered: October 2009
|
Junior Member |
|
|
Hello,
I am trying to allow users to choose the text value of addresstype in a form with poplist.
In the addresstype table I have two columns - ID and name.
In the form I want users to choose the "name" and it will be decoded to the ID with a WHEN-VALIDATE-ITEM trigger on the "name" field which I have set as a non-database field.
The problem is when I query the data back, the POST-QUERY trigger puts the "name" back into the non-database field and the WHEN-VALIDATE-ITEM trigger fires and puts the ID back into the field I just populated from the database with the query.
How can I do this without the WHEN-VALIDATE-ITEM trigger from firing when I am querying?
|
|
|
|
| Re: Poplist issue [message #426392 is a reply to message #426297] |
Thu, 15 October 2009 04:06  |
cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
use
set_item_property(<block.item>, item_is_valid, property_true);
After you assign its value in the post-query trigger.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
