Hi all,
Using a Web Form, I want to insert value in my database. But before to insert, I need to check if the value doesn't exist.
This is my database
To help me, I created the field RID. This is my field that I will check.
RID = fk_marque & modele
Next, this is my form
RID = ID_Marque (hidden) & Modèle. I used javascript to merge them.
Next, I'm trying to populate the field "Erreur" using Search rules.
If Form's RID = Database's rid, then Form's Erreur = Database's id_modele.
As you can see in my previous picture, the field Erreur is empty and IDK why.
Need some helps please.
Regards