jemthoreau
New member
I have a form that I'm going to use to display a single staff information record. One of the fields is STAFF_TYPE_ID which is a number. The number corresponds to a number in another table (STAFF_TYPE) where there is text field that holds the description of the type (Manager, specialist, auditor, etc.) The field name is STAFF_TYPE_DESC.
I want to display the STAFF_TYPE_DESC in a combo box on the form but I want the combo box to be bound to the STAFF_TYPE_ID.
When I navigate through the records I want the description to change depending on the STAFF_TYPE_ID for the current record.
I want the user to be able to select a different value from the combo box (STAFF_TYPE_DESC listed) and have the corresponding STAFF_TYPE_ID be saved in the STAFF table for the current record.
I already know how to setup the form with a dataset, binding source, table adapter, manager, and navigator. I can't seem to figure out how to use a combo box to accomplish what I used to do VERY easily in VB6 and MS Access. I've banged my head on this all day and any help would be appreciated.
I want to display the STAFF_TYPE_DESC in a combo box on the form but I want the combo box to be bound to the STAFF_TYPE_ID.
When I navigate through the records I want the description to change depending on the STAFF_TYPE_ID for the current record.
I want the user to be able to select a different value from the combo box (STAFF_TYPE_DESC listed) and have the corresponding STAFF_TYPE_ID be saved in the STAFF table for the current record.
I already know how to setup the form with a dataset, binding source, table adapter, manager, and navigator. I can't seem to figure out how to use a combo box to accomplish what I used to do VERY easily in VB6 and MS Access. I've banged my head on this all day and any help would be appreciated.