Hi Ryan,
Thank you! That worked adding those column names in my query, now I can see the entries for that column in my drop down.
When I select that drop down I have configured a events to trigger the fields on my page to populate with information relating to that user from my table. I'm using the following format in my SQL driven field to populate my Employment Type field, not sure if its correct:
SELECT EmployType AS QuestionOptionValue, EmployType AS QuestionOption FROM User_Access_Request_Form Where EmployeeName = '()'
It looks like the form is trying to process something but nothing is populating on the field.
Should I be using this command in both the Question Events and the Advanced Field Options?
Thanks,
Heather