Per my previous post asking which program to be used, I am going full stop on the Excel sheet and switching to Access.
I am struggling to wrap my head around how to do tables that handle changes for a job. I will try to lay out my thoughts.
So far I have made my main table and a couple supporting tables (see attached). I need to make a table that can hold the "base" info for a project (such as the quote being used to issue PO's for). That seems relatively easy enough, as I can integrate that with my other app.
However this is where I start getting lost. How would my next table(s) look to handle changes? I would need to input quantity changes (that is the main thing), but also keep track of comments, attachments and maybe a few other odds and ends.
So for a given project, I would see the base order for the job then see each change made during the projects life time and the financials associated with each change. So at any given time we could look at essentially a snapshot of the financials of a job for each change made, both overall and each individual item.
I think this would be maybe 2 tables? One to hold the base data and the other to hold the changes and tie it back to the overall projectid?
I am struggling to wrap my head around how to do tables that handle changes for a job. I will try to lay out my thoughts.
So far I have made my main table and a couple supporting tables (see attached). I need to make a table that can hold the "base" info for a project (such as the quote being used to issue PO's for). That seems relatively easy enough, as I can integrate that with my other app.
However this is where I start getting lost. How would my next table(s) look to handle changes? I would need to input quantity changes (that is the main thing), but also keep track of comments, attachments and maybe a few other odds and ends.
So for a given project, I would see the base order for the job then see each change made during the projects life time and the financials associated with each change. So at any given time we could look at essentially a snapshot of the financials of a job for each change made, both overall and each individual item.
I think this would be maybe 2 tables? One to hold the base data and the other to hold the changes and tie it back to the overall projectid?