Well, it's an employee schedule. So one employee sees more than one client. I have it set up like you suggest, but it won't let me type in a client ID.

---

Reply from Richard Rost:

OK, now make an EMPLOYEE form with a SUBFORM. The subform is based on your junction table. The combo box on your subform shows a list of clients from the client table. If you want to DISPLAY the information from each client in the subform, use a query that includes just the junction table with a one-to-many join to the client table. That should make it an updateable dataset.