I have created a table with fields as Name, Phone Number, Address, etc. And have added data into it.
The requirement is I want to create an generic edit form for this table to update the data in it, In this Edit form I’ll be having a text box that takes in Phone number as input and as soon as I enter Phone number .Using the Phone number I added it has to query through the table and find the record having same phone number and fill the edit form with the data of the record that was found.
Now here as soon as I enter phone number, the fields Name and address should fill with the record data that was found with the phone number entered.
Is there any way to do this?