Let me start off by saying I am new to Access...I have a data entry form that the user is going to enter a project for a customer. There will potentially be numerous projects. For each project the user needs to be able to enter a Sales Rep for each project. I have a table tblSalesRep listing all reps and those names show up in the combo box. The problem is when I change the Sales Rep for a new project it changes it for all projects. Thanks in advance.