To start out, I would like to say hello to everyone. I just joined the forum. I have built a small database in access 2007 (my first time). It works, but not as well as I would like, so I'm trying to refine it. I am trying to do it the correct way this time as opposed to making it work which is what happened with the original.
The current database is used to collect batch data on products we are producing.
I have a table for products (tblProducts). This contains all of the raw materials need to produce that product. I have another table for empoyess (tblEmployees). This contains all the information related to the empolyees. Then a third table to collect the data (tblMainProduction). This table uses the drop down menus in some of the fields which are populated by tblProducts and tblEmployees.
I also have a form (frmPlant) which allows someone to enter information into the MainProduction table.
Currently there is a batch number field in the Main Production table that is used as the primary key. In our process each batch goes through 3-4 different processes. There is data that needs to be entered during each process. Currently all of the data for all the processes is entered on one form. For example, when the product is made and a record is entered using the plant form, during this step a batch number is given, and about half of the fields in the form are completed. Then down the line, the product is packaged. Another person then has to use the record arrows to look up the same record on the form, and complete the form. All the information is then stored in one row on the Main Production table, tied to one batch number.
What I would like to acheive is to have the two seperate forms. For example one form for the production division that would generate the batch number and it's relative information. And then a seperate form for the packing department, but still have all of the information stored on one line in the main Production table, tied to one batch number.
Basically I am asking is there a way to have two forms coorespond to the same table, and edit the same record?
I hope this isn't too confusing. I read the thread about posting questions, and I think I still screwed it up.
Thanks for the help,
Jason
The current database is used to collect batch data on products we are producing.
I have a table for products (tblProducts). This contains all of the raw materials need to produce that product. I have another table for empoyess (tblEmployees). This contains all the information related to the empolyees. Then a third table to collect the data (tblMainProduction). This table uses the drop down menus in some of the fields which are populated by tblProducts and tblEmployees.
I also have a form (frmPlant) which allows someone to enter information into the MainProduction table.
Currently there is a batch number field in the Main Production table that is used as the primary key. In our process each batch goes through 3-4 different processes. There is data that needs to be entered during each process. Currently all of the data for all the processes is entered on one form. For example, when the product is made and a record is entered using the plant form, during this step a batch number is given, and about half of the fields in the form are completed. Then down the line, the product is packaged. Another person then has to use the record arrows to look up the same record on the form, and complete the form. All the information is then stored in one row on the Main Production table, tied to one batch number.
What I would like to acheive is to have the two seperate forms. For example one form for the production division that would generate the batch number and it's relative information. And then a seperate form for the packing department, but still have all of the information stored on one line in the main Production table, tied to one batch number.
Basically I am asking is there a way to have two forms coorespond to the same table, and edit the same record?
I hope this isn't too confusing. I read the thread about posting questions, and I think I still screwed it up.
Thanks for the help,
Jason