Table 1 - Employee Data
Table 2 - Skills Data
Table 3 - Resources
Objective is:
Step 1: Pull employee information from Table 1 by Employee ID #. This Combo box will auto populate my form while updating Table 3 on the back end. >> This works with simple code (see below)
------------------------------------------------------------------------------------------
Code that populates Table 3 for Step 1:
Private Sub cboLogin_Change()
Me.txtFirst.Value = Me.cboLogin.Column(1)
Me.txtLast.Value = Me.cboLogin.Column(2)
Me.txtFull_Name.Value = Me.cboLogin.Column(3)
Me.txtEmail.Value = Me.cboLogin.Column(4)
End Sub
----------------------------------------------------------------------------
Step 2: Skills section pulls from Table 2, must be able to multi-select data (Access, SQL, VB) and update table 3 in the skills field.
I can create a combo box with multi-select capabilites, but this does not update Table 3. The skills field is set to text.
What am I missing?
so, your table relations between Resources and tblSkills will be 1 to many on the Employee ID field
Resources tblEmpSkills
EmployeeID 1 --- > M EmployeeID
SkillID