This topic is locked

How make the lookup wizard prevent duplicate value of more than one field

6/10/2020 12:36:29 PM
PHPRunner General questions
C
caese author

Hello! How do I make the lookup wizard avoid the duplicate value of more than one field? User can enter code (individually can be duplicated) and color (individually can be duplicated) but (code + color) must not be duplicated. Sorry about my english.

Sergey Kornilov admin 6/10/2020

This can be done and you need to do this manually using field events. I understand that you use two lookup wizards where users enter their own values. You need to implement 'change' field event for both fields, get the value of both, check for a duplicate and display some message or clear the field.
https://xlinesoft.com/phprunner/docs/field_events.htm