When a user signs into the first page they will add all of the information in. For every user from that point on they would need to enter the invoice number to pull up the data so they could fill out their page. I have a space PC here that I want to use as a server (intranet based) that will store all of the data for each invoice. Each time someone new worked the part the invoice number is used to pull up the record so that all of the data stays in that one file. We work several parts at one time so the files have to be set up by invoice number to keep everthing straight.
These will make up one large record that we can access at any time if there is a problem with one of the parts so we can see who did not do their job properly. If needbe I can private message you contact information so that we can talk. I know this is still pretty vague and I am sorry, I have a hard time expaining stuff in type. Below is an order of operations.
1: user opens file with invoice # and verifying information as to id and who pulled the part, if it will be a shipment or delivered so on. This creates the file such as 12345
2: second user receives the part and invoice. They click on lens and only the field invoice would show, they enter invoice 12345 and this would cause the lens page to open for him to fill out. They enter all of the information into it. As long as the part is marked good in all fields they can save and move on to the next invoice. If their is a problem with the part then that would trigger one of two fields to work, the replacement or repair file.
3 based off of the questions answered, say bad tab replace lamp was chosen, when the invoice number was entered, the replace page would show up to be filled out. Once it is saved it would trigger the lens file to open back up when the invoice number was entered again to start the cycle over.
4 once the lens is done and saved the next person entering the invoice number would be placed on the housing file to do what they need to do. Again if there are any problems checked it would automaticly put the next user on the repair or replace file to be filled out before going to post inspection.
5 Following the mapping above the post, final, and then shipping files would be filled out in sequence.
6 All of this would happen while other parts are being done at the same time. So we would have a constant flow of new files being created by invoice number on the server while other parts are being worked. Each file is stored on the server and can be accessed by file number from the form page or directly via excel on a CSV file format.
I hope that clears up what I am trying to accomplish. I am sorry if I just made things even more confusing.
Dave
