| Validating Items - checking against Items in the same block. [message #357495] |
Wed, 05 November 2008 10:59  |
rm_mainframe
Messages: 8
Registered: October 2008
Location: Liverpool, UK
|
Junior Member |
|
|
Hello,
I'm working with a form that contains Usernames and Real Names.
In this case, the Usernames are a PK field, so on the username item, I've added a when-validate-item trigger that checks against the table that I'm inserting into, as well as sys.user$.
My question is:
How do I validate the usernames against other usernames within the same block? They haven't been saved yet, as the "commit form" is last, so, the when-validate-item trigger doesn't see the duplicates, as it's looking at the external table and sys.user$
What's the best way to check?
I've tried turning on (yes) the Primary Key value in the property pallate, but it didn't have any effect. Is there an easy way?
Ron.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
