I am working on a new DB for something that clearly has not been done yet. As I have been able to find nothing on it. However, I need to start from the begining and I am having trouble setting up the tables. (I am new to Access and have learned alot already but not when setting up tables)
I have set up different tables... The first table is Employee First Name, Last Name and Employee ID(this is an auto number). The second table is Employee ID (same as First Table) and ONCallRotation( autonumber). The Third Table is Shift, Shift Start time, Shift End time.
I have set up a joining table to include Employee ID, First Name Last Name, On call Rotation and Shift.
What I need to do is be able to a new employee (First Name and Last Name) via a "New Employee Form" I have created which links to Employee table...and have the other tables automically update with the new info...ie second table add employee id and oncallrotation( which should create automatically via autonumber) and then joining table to add firstname, lastname and employeeid, on call rotation.
Is there anyway to do this. I am stuck. I am using access 2000 on windows 2000.
Thank you in advance for your help.
Nick
I have set up different tables... The first table is Employee First Name, Last Name and Employee ID(this is an auto number). The second table is Employee ID (same as First Table) and ONCallRotation( autonumber). The Third Table is Shift, Shift Start time, Shift End time.
I have set up a joining table to include Employee ID, First Name Last Name, On call Rotation and Shift.
What I need to do is be able to a new employee (First Name and Last Name) via a "New Employee Form" I have created which links to Employee table...and have the other tables automically update with the new info...ie second table add employee id and oncallrotation( which should create automatically via autonumber) and then joining table to add firstname, lastname and employeeid, on call rotation.
Is there anyway to do this. I am stuck. I am using access 2000 on windows 2000.
Thank you in advance for your help.
Nick
Comment