Access Database - Wrong column being saved
Posted on 2013-11-26
I have two tables on my database called;
Data and Providers
Providers is made up of approx. 10 columns which are;
ID, Number, Name etc.
I have a form which has a drop down made up from the providers table, and when a record is saved, it saves the value to the Data table.... however....
On the dropdown box, it uses a SQL script to list the name, rather than the first column of ID, but when the record is saved, it saves it as the ID number, and NOT the name which is in the box on the form.
What am I doing wrong, and what do I need to do to resolve?