SQL like queries.

Dear All,

I have 2 forms with 2 views created on my Zoho creator. I am not using the ids generated by zoho, because the forms will use ID entered by the user (just because this a requirement from the place I work).

So, I am trying to write a script that will do the following:

while the user is entering data into form B, he will enter the ID from one item from form/view A. After the ID is entered, it will show the information from that item into the form B, and some fields from form B will be automatically filled.

So my question is, is it possible to do a query like: retrieve the item where input.id == viewA.id?

Thanks everyone in advance.