Access newbie here.
I’m using Access 2010 and trying to create my first database. I want to create a work order and inventory DB. I have the following tables listed.
Employee Table
1.EmplyeeID
2.Employee name
3.Employee Title
4.Employee Hourly Rate
Equipment Table
1.EquipID
2.EquipPartNumber
3.EquipHourRate
Materials Table
1.MaterialsID
2.ItemNo
3.Description
4.InStock
So, I want to create a workorder form with the top part to fill out the initial information, then have a subform or tab to fill in the employee, (can be multiple employees) from a drop down, which will autofill in their hourly rate. Then, have another subform or tab to fill in the Equipment and autofill hour rate..etc. Same with Materials. So, my first question is how to go by the relationship between the tables and, should I build a new table named “WorkOrders” to store all of this information? I have many more questions but just need to figure out the best way to start. Thank you very much!
I’m using Access 2010 and trying to create my first database. I want to create a work order and inventory DB. I have the following tables listed.
Employee Table
1.EmplyeeID
2.Employee name
3.Employee Title
4.Employee Hourly Rate
Equipment Table
1.EquipID
2.EquipPartNumber
3.EquipHourRate
Materials Table
1.MaterialsID
2.ItemNo
3.Description
4.InStock
So, I want to create a workorder form with the top part to fill out the initial information, then have a subform or tab to fill in the employee, (can be multiple employees) from a drop down, which will autofill in their hourly rate. Then, have another subform or tab to fill in the Equipment and autofill hour rate..etc. Same with Materials. So, my first question is how to go by the relationship between the tables and, should I build a new table named “WorkOrders” to store all of this information? I have many more questions but just need to figure out the best way to start. Thank you very much!
