Hello,
I want to build a database for our workshop tools along with issue and return record so that equipment could be managed in effective way. Issue is, I am not able to understand/get an idea that how to manage components with it. For instance, I have a main equipment say grinding machine which has several components other than the machine itself like disk, spanner, L-keys etc. Most of the time the machine is issued to a person along with most of the components like 8 out of 10, some time only specific component is required by a person and is issued and rarely machine with all of the related components are required by the person and are issued to him. Currently all this is done on paper register. Now the questions/concerns are:
I want to build a database for our workshop tools along with issue and return record so that equipment could be managed in effective way. Issue is, I am not able to understand/get an idea that how to manage components with it. For instance, I have a main equipment say grinding machine which has several components other than the machine itself like disk, spanner, L-keys etc. Most of the time the machine is issued to a person along with most of the components like 8 out of 10, some time only specific component is required by a person and is issued and rarely machine with all of the related components are required by the person and are issued to him. Currently all this is done on paper register. Now the questions/concerns are:
- Should I make separate tables for machines and components and then link the third table or can I make only one table in which machine and components are written and link of machine with the component is make in second table. My preferable way is the later one as fields for machine and component are almost identical and will also ease me at the time of issue of machine and components independently in a single form but I am not sure if it is recommended way and will not create problems in future.
- How will I link machine with components if second method is used from point 1 in which machine and components are in the same table.
- Can I issue machine and/or components to a person using two listboxes by using add remove button. i.e. I select few items in the left listbox and then click on add button which will add the selected into the right listbox and similarly remove from right listbox to using remove button.