I'm making a database for a non-profit and I have a volunteer table attached to an volunteer input form. In the volunteer form there's a drop down box that pulls from a "contributors extended" query. "Contributors extended" has a column that takes the last name and first name columns from the contributors table and combines them into a full name for use in other parts of the database.
My problem is that the lookup box in the volunteer form shows all of the names, but when it stores the data in the table it uses the ID number from the contributor table. While these numbers are correct and I'm fine with the data being stored this way, I'm trying to use a volunteer subform in the events form to display who volunteered at what event, and I can't get the box that refers to the volunteer name to display the name instead of the number. The box shows the number but when I click the drop down arrow it still shows all of the names in alphabetical order, so it knows what data these numbers are attached to. I just simply want the names to show instead of the numbers.
Is there anything in the properties that I could change or could I alter the query sql to display the name instead of the number?
Any suggestions?... thanks in advance
My problem is that the lookup box in the volunteer form shows all of the names, but when it stores the data in the table it uses the ID number from the contributor table. While these numbers are correct and I'm fine with the data being stored this way, I'm trying to use a volunteer subform in the events form to display who volunteered at what event, and I can't get the box that refers to the volunteer name to display the name instead of the number. The box shows the number but when I click the drop down arrow it still shows all of the names in alphabetical order, so it knows what data these numbers are attached to. I just simply want the names to show instead of the numbers.
Is there anything in the properties that I could change or could I alter the query sql to display the name instead of the number?
Any suggestions?... thanks in advance