Hi,

I am creating a patient record database for a small doctor's clinic in Zoho Creator. I have two forms:

1) Patient Info

with information like Name, Address, Telephone Number; and

2) Visits

with information like Name, Date of visit, Illness that day, Treatment prescribed. Each patient has one record in the "Patient Info" form, and one or more records in the "Visits" form. 

This is my question:

I would like to create a report for each patient with their information and a summary of each visit. I want this form to have a search box. When I enter a patient's name into the search box, the "on click action" calls an html view that displays that patient's record from the "Patient Info" table, as well as all the records in the "Visits" table that contains that name.

I tried to follow the instructions here: http://blogs.zoho.com/creator/creating-a-search-interface-in-zoho-creator , and I got the search form working. However, the instructions about the html view just say "Create the required HTML view with parameter, e.g. searchParam to pass the search key." This is not enough for me to figure it out.

How exactly do I write html code that says:

Take the input parameter (the name I type in) and return the record from the "Patient Info" table where Name = parameter, then return all records from the "Visits" table where Name = parameter?

Thanks so much!