Drop-Down list showing 2 fields from access database

[Former Community Member]

Hello,

currently I have a drop down list that is populated from the name of a record from my access database.

I would like to have a single drop down list that displays both the name of the record and the date the record was created. I currently have a field for both the name and the date in my database.   The reason I need this is because I have duplicate names in the database but multiple records for the same person according to date.

my current drop down list

var sDataConnectionName = "DataConnection";        //    example - var sDataConnectionName = "MyDataConnection";
var sColHiddenValue = "ID";            //    example - var sColHiddenValue = "MyIndexValue";
var sColDisplayText = "Name";            //    example - var sColDisplayText = "MyDescription"

This pretty much the same as the typical adobe example that is available.

Thank you for your help.