Hi (again)!
All right, I have something more I'd like to do that I think will make my users' lives easier (and allow for fewer mistakes, hopefully.) Problem is, I'm not sure how to do this...
I've got a database which holds all the employees in the agency, plus information on their positions and all that. The main table is tblEmployees and the primary key for this table is TDNo, which is a pre-assigned unique ID number for each employee.
There's a second part to the database which holds information on positions posted and applicants to that position. It tracks each application to each position. There's a tblApplicants which has a field for TDNo, in case the application came from within the agency.
What I'd like to do is have a command button on my application tracking form that hires the applicant to that position. This is where I get myself confused. This is what I'd like to happen:
First: a message box which asks "Are you sure you want to hire [applicant] to position [PositionNo] ([PositionTitle,Location])?"
Then: If the person clicks yes, it will check for the presence of a TDNo, and if there is one, it will change the position number for that employee in tblEmployees and ask for a start work date.
If there is no TDNo, it will ask the user for a TDNo, and start a new record for tblEmployees, taking the name fields (last and first) and position number from the application. It will also ask for a start work date.
Is this too complex for poor inexperienced little me? I think it would make things so much easier for the user, so I don't care if it takes me a while to grasp... I just have no idea even where to start.
Thanks again in advance. Y'all are great. (woo-hoo)
--Sara
All right, I have something more I'd like to do that I think will make my users' lives easier (and allow for fewer mistakes, hopefully.) Problem is, I'm not sure how to do this...
I've got a database which holds all the employees in the agency, plus information on their positions and all that. The main table is tblEmployees and the primary key for this table is TDNo, which is a pre-assigned unique ID number for each employee.
There's a second part to the database which holds information on positions posted and applicants to that position. It tracks each application to each position. There's a tblApplicants which has a field for TDNo, in case the application came from within the agency.
What I'd like to do is have a command button on my application tracking form that hires the applicant to that position. This is where I get myself confused. This is what I'd like to happen:
First: a message box which asks "Are you sure you want to hire [applicant] to position [PositionNo] ([PositionTitle,Location])?"
Then: If the person clicks yes, it will check for the presence of a TDNo, and if there is one, it will change the position number for that employee in tblEmployees and ask for a start work date.
If there is no TDNo, it will ask the user for a TDNo, and start a new record for tblEmployees, taking the name fields (last and first) and position number from the application. It will also ask for a start work date.
Is this too complex for poor inexperienced little me? I think it would make things so much easier for the user, so I don't care if it takes me a while to grasp... I just have no idea even where to start.
Thanks again in advance. Y'all are great. (woo-hoo)
--Sara