G
Guest
Hi
I have a form that looks like this:
Employment number (Comes from a table called Employment)
Name (comes from a table called employment)
Course 1 (combo box where selectied values comes from a table named Courses)
Course 2 (combo box where selectied values comes from a table named Courses)
Course 3 (combo box where selectied values comes from a table named Courses)
In the table employment I have a field called courses. I want the three
combo boxes to write the values selected in the box, to the same field
"courses".
Fx.
If there is a value selected in combo box 2, in should dublicate the row for
that employment number and write the value selected in combo box 2 in field
"Courses". If there is a value selected in combo box 3, it should dublicate
the row for that employment number and write the value selected in combo box
3 in field "Courses". and so on.
The table should in the end look some what like this
Employment number Name courses
1 Johan metal (Course selected in
combobox 1)
1 Johan access (Course selected in
combobox 2)
2 Lis "Emty if no
courses selected that employment number"
Please help me. Thank you.
I have a form that looks like this:
Employment number (Comes from a table called Employment)
Name (comes from a table called employment)
Course 1 (combo box where selectied values comes from a table named Courses)
Course 2 (combo box where selectied values comes from a table named Courses)
Course 3 (combo box where selectied values comes from a table named Courses)
In the table employment I have a field called courses. I want the three
combo boxes to write the values selected in the box, to the same field
"courses".
Fx.
If there is a value selected in combo box 2, in should dublicate the row for
that employment number and write the value selected in combo box 2 in field
"Courses". If there is a value selected in combo box 3, it should dublicate
the row for that employment number and write the value selected in combo box
3 in field "Courses". and so on.
The table should in the end look some what like this
Employment number Name courses
1 Johan metal (Course selected in
combobox 1)
1 Johan access (Course selected in
combobox 2)
2 Lis "Emty if no
courses selected that employment number"
Please help me. Thank you.