Richard, I have watched all the lessons on Many to Many Relationships, the Relationship Seminar, the Action Queries, etc and cannot find an answer to my problem.  I have a Many to Many situation in which teachers hold faculty positions at several Universities, and a University will have many teachers.  I have all the data which I have imported from Excel Spreadsheets into tables: SchoolT and TeacherT.  Now I need to get it straightened out via a junction table.  Out of about 750 Teachers and 300 schools there are about 100 teachers with at least two schools.  Can you point to the lesson in which you might have covered something that would help in this problem.  I can do it by hand, but that is tedious at best.  Thanks.

---

Reply from Richard Rost:

This all depends on how you have your data set up. You've got the schools and the teachers in their respective tables, but where do you have listed which teachers belong to which schools? If that's in a spreadsheet somewhere, you may be able to import it and then use an UPDATE QUERY to change the school name, for example, to an ID value, and then use an APPEND QUERY to add all of those to a junction table. Without seeing a sample of your data, I really can't tell. I will say that in most cases like this, you can't easily get away from some manual data entry. Hire an intern. :)