I did it myself.  No inter!!  I'm "on vacation" (ha).  I had imported both the schools and teachers into separate tables.  I then exported them in to separate Excel spreadsheets with the ID numbers, I matched the names up (with some effort), changed the numbers by hand and reimported them into Access.  No perfect, but I am getting there.  What's more, my wife, for whom this is all being done, SEEMS to be using the not yet complete database successfully.  I don't tackle small problems to begin with. Actually, I have three separate databases in Act! that I am trying to consolidate into one in Access.  I think it will work, but NONE of it deals with products, vendors, etc, so I have to use my imagination to interpret what you teach into my situation!  But I think I can at about the third or fourth time through a lesson.

---

Reply from Richard Rost:

That's wonderful. Playing around with it like that is the best way to learn... watch my examples and then figure out how to apply them to YOUR project.