I have an existing spreadsheet that is used by another department.
I track data from their spreadsheet in my MSAccess database. What I would like is to make it so that the "F_Name" column in their spreadsheet is fed by a field in my Access database.
In other words, when you start to type "SMITH J" then the dropdown list will limit itself to "SMITH JOHNATHAN" and "SMITH JOHN C".
HOWEVER, occasionally (rarely) they will have a name that I don't have on my list.
The "F_Name" field is a full name, and is common to both documents, column A on the spreadsheet, and table TBL_MASTER_NAMES in the database.
Thanks,
Tony
I track data from their spreadsheet in my MSAccess database. What I would like is to make it so that the "F_Name" column in their spreadsheet is fed by a field in my Access database.
In other words, when you start to type "SMITH J" then the dropdown list will limit itself to "SMITH JOHNATHAN" and "SMITH JOHN C".
HOWEVER, occasionally (rarely) they will have a name that I don't have on my list.
The "F_Name" field is a full name, and is common to both documents, column A on the spreadsheet, and table TBL_MASTER_NAMES in the database.
Thanks,
Tony