This sounds very similar to my situation https://www.accessforums.net/forms/c...ous-35615.html, if I am following correctly. I have a main form that uses a date as the value along with an autonumber primary key and is stored in a table called TestDate. The table just below that is the TestBuildings table with an autonumber primary key. That table just below TestBuildings is ChamberDays with an autonumber primary key. I have FKs on each table to create a one to many relationship at each table. Essentially, there's one date to many buildings, one building to many chambers. I have a subform tied to the table TestBuilding on the form that allows a user to select the day. Bottom line, can I use code similarly to what has been mentioned in link to copy both the building data and the chamber data located in two separate tables and do it from an action on the form where the user selects the date the test takes place? I have looked at the Allen Browne solutions and it hasn't clicked yet. I am hoping my brain will engage to get this into a solution. Thanks for any help.