| Validation in Multirecord Block [message #388327] |
Tue, 24 February 2009 06:07  |
drajeshonline
Messages: 11
Registered: February 2009
|
Junior Member |
|
|
Hi all
please help me I got stuck to solve this problem ..problem is like ..I ma having a multi record block which is used to calculate the Interest Rate for a given period.So I need to validate the Interest period whether it is being used earlier.in case if it is used user is not allowed to choose that start period. so to achieve this I need to check the previos record start date also since in when-validate-item we can not navigate i m using key-next-item.it s woeking fine ..So can anybody tell me same validation I canacheive by using When-validate-item.
thanks
Rajesh Lionel
|
|
|
|
| Re: Validation in Multirecord Block [message #388707 is a reply to message #388327] |
Thu, 26 February 2009 00:00  |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
I suggest doing a 'commit' each time you go to the next record, that way any used 'period' will exist in the database.
Then in the 'When-Validate-Item' trigger you do a search of the database and if the 'period' has been 'used' just do a 'raise form_trigger_failure'.
David
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
