I am working on a project to add students to classes, I have a class table and and instance table (classes may happen more than one time) and I am trying to put data from both of these into a new class roster table. I have two identifiers, classid which is unique and sequence no, that is unique to the classid, I can make this work with out using VBA but it will not update when I use a second sequence no. Is there a simple solution? I have tried using a query and it will bring up the data but not fill in my form.