Hi, all -- here's the situation:
1. I have a table called People with fields called ID (the primary key) and Employee_ID.
2. I have another, imported table called Enrollment that also has an Employee_ID field.
3. I'm trying to put the data from People.ID into a new Enrollment.ID field.
Since I'm still very much an Access newbie I'm not sure how to do it. I tried creating an Update query but got 0 records (hey, that's better than an error message, right?). Thanks for any help you can offer.
1. I have a table called People with fields called ID (the primary key) and Employee_ID.
2. I have another, imported table called Enrollment that also has an Employee_ID field.
3. I'm trying to put the data from People.ID into a new Enrollment.ID field.
Since I'm still very much an Access newbie I'm not sure how to do it. I tried creating an Update query but got 0 records (hey, that's better than an error message, right?). Thanks for any help you can offer.