Attached is the database.
I am trying to get the FrmEvaluations to be bound by DOA, then have it populate Advisor and the sub form will show previous evaluations plus the ability to create new (new EvalID.
I have a database with the following tables.
1. tblDOA (DOA is the promary field which is name of DOA)
2. tblEmployee (empID, empLastName, empFirstName, empDOA - used to link to tblDOA)
3. tblEvaluations (EvalID, evalEmpID(links to tblEmployees), evalDate,EvalComments)
4. tblEvalDetails...
I have a database with the following tables.
1. tblDOA (DOA is the promary field which is name of DOA)
2. tblEmployee (empID, empLastName, empFirstName, empDOA - used to link to tblDOA)
3. tblEvaluations (EvalID, evalEmpID(links to tblEmployees), evalDate,EvalComments)
4. tblEvalDetails...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.