Hello, I am quite new to access, but seem to be getting there now. I am producing a database, and I want to make a data entry form that is not bound to a table, as I do not want half completed records to be saved to the database.
I have used a append query for where I have information going into one table, and this worked great.
What I am trying to do now though, is have a data entry form for a main table 1, as well as another table 2 that has a one-to-many relationship. The common field is called ‘SchemeID’ which is an ‘autonumber’ in table 1, and a ‘number’ in table 2 (to enable more than one record to be stored [in table 2] for each of the main records [in table 1]).
Therefore my overall goal is a form/forms that can enter a single record onto the table 1 without saving (until the db is told to), and also be able to add multiple records to the table 2 (again, not until the db is told to do so), but the records in table 2 need to have the same autonumber that is generated from table 1.
I hope this makes sense! Can anyone think of an easy way to achieve this? Many thanks