I have a table (tblRepSup) the shows fields: RepName, Supervisor, SupSchedule. I have since revised it to break up the table into separate tables tblRepName, tblSupervisor, my question is, what is the easiest why to reassociate the supervisors to the reps? So that I can still add or remove reps/sups individually. I also an creating a form that brings the information together RepName, SupName, Wk1, Wk2.......how do I get all these fields together? I assume I can do it with accessing the info from a query, but i need to get step one set up first. Any help would be GOLD.