I am new to Zoho and still learning the ropes. We have a project that we think would fit Zoho well. We would like to use Zoho Creator as a look up table. To do this we would like to upload a SQL Select query to the Zoho database that the creator would use for the lookup. This would need to be done several times a day as the data is constantly changing.
I have downloaded the uploadtool but as of yet have not gotten it to work. In reading all the info that comes with it I see a lot of references to Zoho Reports. I am not trying to upload to reports but to the Zoho Creator where I have a form with two test records in it. A lookup control and a simple line control. When I select the lookup item it responds with the correct item in the sample line. How can I populate the database behind this from our Sql Database?