I have two questions
(1) I am trying to make a database that shows a list of unique devices. These devices will go through a process that entails:
-assigning the device to initial review
-initial review will then do one of two things, send it to a final verifier or send it to engineering review with a comment on what is wrong
-the verifier will have the task of assigning the device to initial review and verifying.
-Engineering review will do the above tasks as well but also perform the engineering review on the devices that need it and then verify.
My first question is that I have set up only two tables for this one that just has the personnel and there specific group, and one that has all the information on the devices such as where the device is in the process etc. Am I blatantly wrong in choosing to use only two tables?
(2) My second question is that there are individual devices which will have a primary key, however I would like to be able to assign the devices to a specific person in initial review based on groups or types of devices. I do not want this individual to be able to see the groups just the unique individual devices assigned to them. So for instance, I would like a form that lists all the groups and shows how many devices are in each one of these groups and then the assigner can assign all of those devices to one person on initial review with one click. Then another form for initial reviiew which shows all the individual devices assigned to that specific person. Is this possible?
(1) I am trying to make a database that shows a list of unique devices. These devices will go through a process that entails:
-assigning the device to initial review
-initial review will then do one of two things, send it to a final verifier or send it to engineering review with a comment on what is wrong
-the verifier will have the task of assigning the device to initial review and verifying.
-Engineering review will do the above tasks as well but also perform the engineering review on the devices that need it and then verify.
My first question is that I have set up only two tables for this one that just has the personnel and there specific group, and one that has all the information on the devices such as where the device is in the process etc. Am I blatantly wrong in choosing to use only two tables?
(2) My second question is that there are individual devices which will have a primary key, however I would like to be able to assign the devices to a specific person in initial review based on groups or types of devices. I do not want this individual to be able to see the groups just the unique individual devices assigned to them. So for instance, I would like a form that lists all the groups and shows how many devices are in each one of these groups and then the assigner can assign all of those devices to one person on initial review with one click. Then another form for initial reviiew which shows all the individual devices assigned to that specific person. Is this possible?