I am pretty new to access and I have a database that I am trying to make which uses a main table (Rooms_Table) where every record is a room. This table is being fed by "Rooms_Mainform". I have embedded a few sub forms into this mainform which has notes associated with each room to create a one to many relationship. I have linked the two forms in the relationship panel (Mainform ID to the Record # column and changed the control source for the record # column to match the ID number on the mainform. When I open the mainform and try to create a new record in the subform, the Record# box shows correctly but when I save the record and view it in the table, the Record # cell defaults to "1" which is the default value for that column.