I have a combo box;
When a record is selected, my combo box populates the ID. I want to have the combo box be just the DeptName column but to populate the DeptID when DeptName is selected: like this;
so when Advertisement is selected, i want the combo box to populate 34 as the ID in my table. How can i accomplish this?