I am creating a simple Access database. I have a table for Sessions and I am trying to create a form to enter new sessions. I need to be able to first select the Client from the Client table, then I need to be able to select a Campaign from the Campaign table, but only the campaigns related to the chosen client should appear. Next, I need to assign a Client Rep to the session, but I only want to be given the choices of the client reps that are related to the clien that was first chosen. Then I need to be able to fill in the rest of the data for the Session table. I can get the form to limit the campaigns by the customer, but it keeps giving me all of the client reps to choose from instead of just the ones that are assigned to the specified client. I attached a Word document that shows the relationships. Can someone give me some advice, please? Thank you!