hello,
I have an existing database that i currently use to store detailed information on hundreds of machines, instruments and other equipment. This is stored in [tblEquipment]
I am building a new project management database for installations of new equipment/machines in order to assist me in keeping track of the project from start to finish, this includes budgeting, purchasing and data entry for new equipment.
My Idea.
I have a main navigation form which uses several tabbed forms/subforms for my project. One particular form/table i use to keep track of equipment i need to purchase to install. This is a continuous form [frmProjectPurchases] that lists all the equipment. This goes into [tblProjectPurchases]
I would like to add another form [frmEquipmentDataEntry] that allows me to pull all the equipment i purchased from [frmProjectPurchases] but will allow me to input all the details on said equipment into [tblEquipment]. I was thinking of scrapping [tblprojectpurchases] and putting all this into [tblequipment] but alot of purchases will not actually have any details saved for them since they are redundant parts.
What would be the correct approach?
I have an existing database that i currently use to store detailed information on hundreds of machines, instruments and other equipment. This is stored in [tblEquipment]
I am building a new project management database for installations of new equipment/machines in order to assist me in keeping track of the project from start to finish, this includes budgeting, purchasing and data entry for new equipment.
My Idea.
I have a main navigation form which uses several tabbed forms/subforms for my project. One particular form/table i use to keep track of equipment i need to purchase to install. This is a continuous form [frmProjectPurchases] that lists all the equipment. This goes into [tblProjectPurchases]
I would like to add another form [frmEquipmentDataEntry] that allows me to pull all the equipment i purchased from [frmProjectPurchases] but will allow me to input all the details on said equipment into [tblEquipment]. I was thinking of scrapping [tblprojectpurchases] and putting all this into [tblequipment] but alot of purchases will not actually have any details saved for them since they are redundant parts.
What would be the correct approach?