when the Chemical Name field is chosen from a drop down the index field would fill with the correct Index number for that chemical. How could this be done? I'm a newbie so explain where and how to make this work on the PDF form.
Set the index number as the export value of each item in your drop-down and then you would be able to use a simple calculation script to populate the text field with it. The script would be:
event.value = this.getField("Chemical Name").value;
Retrieving data ...