By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,988 Members | 1,074 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,988 IT Pros & Developers. It's quick & easy.

Add data to one table...update other tables?

P: 78
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
Apr 18 '08 #1
Share this Question
Share on Google+
1 Reply


puppydogbuddy
Expert 100+
P: 1,923
It sounds like you want to use an autolookup query.....see Access Help on this topic.....and also, this link:
http://office.microsoft.com/en-us/ac...885841033.aspx
Apr 20 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.