Hello!
I've got a table with project info recorded on employee level. There's one column for projectNo, one for employeeNo and a whole bunch of other columns with info regarding that employee's contributions to the specific project.
I'd like a form where you enter projectNo and employeeNo in two combo boxs, have access find the row and then enter info in the other columns with text fields. If such a projectNo & employeeNo combination doesn't exist then access will create a new row for you and then let you enter values as usual.
What's the easiest way to go about this?
Thanks!
I've got a table with project info recorded on employee level. There's one column for projectNo, one for employeeNo and a whole bunch of other columns with info regarding that employee's contributions to the specific project.
I'd like a form where you enter projectNo and employeeNo in two combo boxs, have access find the row and then enter info in the other columns with text fields. If such a projectNo & employeeNo combination doesn't exist then access will create a new row for you and then let you enter values as usual.
What's the easiest way to go about this?
Thanks!
