Hi everyone (sorry about the long post, but I'm not sure if I explained my problem well enough).
I am writing a simple (at least it is supposed to be) database for my personal use. I am a teacher and am trying to design a database to make writing lesson plans easier.
Anyway, the database I am creating is sort of like a wizard - I have numerous small forms that store data into one large table. These small forms are linked to two larger ones, which in turn pass the data to the table. I am running into a problem with this, however. Each table stores the data into its own individual line of data in the table. Instead, I need them to store on the same line.
Here's another way to put it. I fill out the first "wizard" and all the data is stored under a specific lesson number. This was created while designing the table; I made an autonumber field to number each lesson. Next, I click on a button called "Go To Next Step," and a new form appears. I fill this one out and all the data is stored using the next available lesson number. I need this data to store under the same lesson number as the previous form.
So, after this long-winded explanation, my question is: is there a way to link two separate forms to save data to the same line of data in a table?
Any help you could give me would be greatly appreciated.
Ed
I am writing a simple (at least it is supposed to be) database for my personal use. I am a teacher and am trying to design a database to make writing lesson plans easier.
Anyway, the database I am creating is sort of like a wizard - I have numerous small forms that store data into one large table. These small forms are linked to two larger ones, which in turn pass the data to the table. I am running into a problem with this, however. Each table stores the data into its own individual line of data in the table. Instead, I need them to store on the same line.
Here's another way to put it. I fill out the first "wizard" and all the data is stored under a specific lesson number. This was created while designing the table; I made an autonumber field to number each lesson. Next, I click on a button called "Go To Next Step," and a new form appears. I fill this one out and all the data is stored using the next available lesson number. I need this data to store under the same lesson number as the previous form.
So, after this long-winded explanation, my question is: is there a way to link two separate forms to save data to the same line of data in a table?
Any help you could give me would be greatly appreciated.
Ed
