Hello,
I picked up a Database from a colleague, and I came across something.
There is a form which holds a combo drop down box. To source for this combo box are 2 fields. When I am in the form and select the drop down menu, I see all the values (both columns, which I need) which is correct. However, once the form is saved, the table is updated with the first column only, I need the table to update with the second column. Help.
The columns look as such:
Column A | Column B
1a | People | Training
1b | People | Staffing
2a | Technology | Procedures
2b | Technology | Storage
2c | Technology | Training
In the drop down within the form, I see both "1a" and "People | Training" which is what I built. However the table is only updated with "1a"; I want it to update instead with "People | Training".
I picked up a Database from a colleague, and I came across something.
There is a form which holds a combo drop down box. To source for this combo box are 2 fields. When I am in the form and select the drop down menu, I see all the values (both columns, which I need) which is correct. However, once the form is saved, the table is updated with the first column only, I need the table to update with the second column. Help.
The columns look as such:
Column A | Column B
1a | People | Training
1b | People | Staffing
2a | Technology | Procedures
2b | Technology | Storage
2c | Technology | Training
In the drop down within the form, I see both "1a" and "People | Training" which is what I built. However the table is only updated with "1a"; I want it to update instead with "People | Training".