Have read a few forum posts and documentation trying to determine how to pull data into a Creator Form from Zoho Reports.

I know how to store,update and delete records in Zoho Reports from the form, but am struglling to get it to pull data and populate a dropdown list.

What I currently have is a form that is for inputting orders. The field I want to populate is "Supplier". In my database/reports, I have a Suppliers table. I want it to pull in the Suppliers Name for display in the dropdown list, but have a value of SupplierID. Example of data;

SupplierID, SupplierName

ABC123, ABC Supplier

The form should display supplier name for easy to read, but when storing the data, it should save the field as SupplierID. 

I hope that makes sense, any help is going to be greatly appreciated!

Cheers

Russell