I've created a dropdown that that lookup data come from a list in SharePoint. I've got the dropdown field on the form displaying the text value and not the ID, but the column in the record is displaying the value ID. How do I get the record to display the text. Thanks,