I have two tables in my database : Phone Type and Registration.
Screenshot of phone_type table:
Screenshot of Registration Add form
PHONE TYPE field : Lookup from Phone_type table
SERIAL NUMBER : dependent lookup based on PHONE TYPE
It's easy in PHPRUNNER to use dependent lookup feature but the problem is : PHPRUNNER using AJAX to check user input.
For example if i choose and type 111 in SERIAL NUMBER field, phprunner generated app will suggest 111111110 and 111111111
Since Serial number is Classified data, i want user to input serial number manually and check serial number with custom button:
If inputted data is not valid, message : "Not Valid Serial Number".
If inputted data is valid but status = REGISTERED, message : " Serial number was Registered"
If inputted data is valid and status = UNREGISTERED, message : "Serial Number is Valid"
And user can save the add form if Serial Number is valid
