I have two tables in a single database that I just linked in a one to many relationship. I created a main form with a subform, with the One table as the main form, and the Many table as the subform. I did this primarily to make data entry simpler. Prior to this, data from a single data sheet were entered into two different forms, one for each table, sharing a single field that related them for joins, etc., without an existing one to many relationship....