ChrisSedgwick
Registered User.
- Local time
- Today, 22:03
- Joined
- Jan 8, 2015
- Messages
- 119
Hi all,,
I've been asked to work on a new "Installations" section of our database. I didn't design the database itself, so it's always a little difficult to make sure anything new that is implemented works as it should. I won't bore you with all the details regarding the new section as our set-up is a little different. However, The outline basically means we can issue our fitters with what we're calling a "Fitter Order Ticket", which is linked to a job on our system and then to a specific Product within that job. The Fitter Order is linked by
Product ID, which is linked to Phase ID (as we can have many Phases on a job), which is then linked by Job ID.
The set up so far means that we are able to send Fitter Order Tickets as we want and this side of the new section works great!
What I now want to do is to set up a section that will allow us to input what the fitter has actually installed. This way we can run off all types of reports and statements for P & L purposes.
Again, I've created most of the cosmetic stuff however I'm struggling to keep some sort of running total going. So for example,
We send a Fitter Order Ticket to a Fitter for 10 items, they fit 5. We enter 5 into our system. We now how 5 remaining, and preferably we want to know this whenever we issue another tickets for the same Product/Item.
So, we send the remaining 5 as a new Fitter Order Ticket to a different fitter. He sends his invoice back to us and tells us he has fitted 6. Obviously this is over the remaining total and this would need to flag up.
I'm sure that this would be done as an update query, however it's not something I've done before.
Could someone suggest how I would go about doing this?
Thanks in advance.
Chris.
I've been asked to work on a new "Installations" section of our database. I didn't design the database itself, so it's always a little difficult to make sure anything new that is implemented works as it should. I won't bore you with all the details regarding the new section as our set-up is a little different. However, The outline basically means we can issue our fitters with what we're calling a "Fitter Order Ticket", which is linked to a job on our system and then to a specific Product within that job. The Fitter Order is linked by
Product ID, which is linked to Phase ID (as we can have many Phases on a job), which is then linked by Job ID.
The set up so far means that we are able to send Fitter Order Tickets as we want and this side of the new section works great!
What I now want to do is to set up a section that will allow us to input what the fitter has actually installed. This way we can run off all types of reports and statements for P & L purposes.
Again, I've created most of the cosmetic stuff however I'm struggling to keep some sort of running total going. So for example,
We send a Fitter Order Ticket to a Fitter for 10 items, they fit 5. We enter 5 into our system. We now how 5 remaining, and preferably we want to know this whenever we issue another tickets for the same Product/Item.
So, we send the remaining 5 as a new Fitter Order Ticket to a different fitter. He sends his invoice back to us and tells us he has fitted 6. Obviously this is over the remaining total and this would need to flag up.
I'm sure that this would be done as an update query, however it's not something I've done before.
Could someone suggest how I would go about doing this?
Thanks in advance.
Chris.
