I have looked at the documentation examples and Tips on the forum but have not found a solution that uses the Ajax approach to solve my problem.
A user is filling out a form. The first field requires a lookup from another table which is handled with the PHPRunner lookup wizard.
Once the value for this field is selected I want to conduct a quick search through the same table that this form is writing to.
I want to make sure that there is not a duplicate record created if this form is filled out and submitted.
In PHP I would look for a record in this form table where field1 equals the form selection $values["field1"].
But the PHP events can't do this until after the record is processed.
I would like to produce a live immediate warning via Ajax that a record has been found that matches the field selection just made.
Have I missed a tutorial or document that already addresses conducting a search once javascript detects a value entered into a form field?
Thank you for any help.
