I'm wondering how to create a dropdown list in creator with data imported and synchronized periodically from a zoho report table or SQL Table ?

For instance, we would like to create a simple form to give an evaluation to one of our suppliers. All our suppliers are stored and updated in our accounting software (base on sql server) and we have already synchronised it in a zoho report table.

We would like  to create a  form where:

1/  the user can search the existing supplier (in a dropdown list) from zoho report table and/or sql table

2/  add en evaluation (from 1 to 5). 

3/ Save and send the result to the sql table and/or zoho report table.

Can you help me ?

Regards,

Yannick,