Hi,
New to the forum, I've used access in the past but drawing a blank at the first stage. :banghead:
I'm currently trying to build a database to store information of customers, suppliers, products, Jobs (address of job, company who have contracted the works, job ID which has already been generated).
All in all my aim is to be able to manage the jobs get material costs for each job and also keep a detailed summary of materials used, which will also in the future include whether job has been invoiced and returned paid.
Unfortunately I'm struggling; because materials can be supplied by around 4 different suppliers, with each holding their own prices, I'm not sure how to organise all my information onto tables so that when it comes to drawing up forms and queries everything is set up in a way which I don't have to go back and re-organise things should there be problems.
Could anyone help me please?
This is how I have it at the minute (I'm open to suggestions of course, and they are appreciated) bare in mind nothing has been created yet, I am still at the pen and paper drawing stage ha
Tables:
Customers> Company Name, point of contact, billing address, city, postcode, email, website, phone and fax numbers
Suppliers> Company Name, Billing address, city, postcode, email, website, portal link, phone and fax numbers.
Materials> Description, supplier, price (dependant on supplier)
Jobs> Job ID (already generated from a previous system), contractor (person paying us to do job) job address, material delivery ticket numbers
On jobs I would also need to include materials and amounts used as well as generating costing's for each job. (hopefully using my materials and supplier tables) Sometimes we do works on the same job but distinguish between each 'phase' by the date the works were done, which would also need to be included.
Like I said any help will be appreciated, just want to make work a lot easier and I know that doing it on access is the way to go. Its just been a while since I built anything from scratch.
****update 14.50 06/03/14:
So I have been looking around and it seems what I actually want to do is merge a order management database with a contractors database to handle all aspects of the working. Such as holding information on contractors, materials used which i can then create reports for job costing's, material summaries for each job etc. But im still finding it difficult
Thanks in advance
R M Harper
New to the forum, I've used access in the past but drawing a blank at the first stage. :banghead:
I'm currently trying to build a database to store information of customers, suppliers, products, Jobs (address of job, company who have contracted the works, job ID which has already been generated).
All in all my aim is to be able to manage the jobs get material costs for each job and also keep a detailed summary of materials used, which will also in the future include whether job has been invoiced and returned paid.
Unfortunately I'm struggling; because materials can be supplied by around 4 different suppliers, with each holding their own prices, I'm not sure how to organise all my information onto tables so that when it comes to drawing up forms and queries everything is set up in a way which I don't have to go back and re-organise things should there be problems.
Could anyone help me please?
This is how I have it at the minute (I'm open to suggestions of course, and they are appreciated) bare in mind nothing has been created yet, I am still at the pen and paper drawing stage ha
Tables:
Customers> Company Name, point of contact, billing address, city, postcode, email, website, phone and fax numbers
Suppliers> Company Name, Billing address, city, postcode, email, website, portal link, phone and fax numbers.
Materials> Description, supplier, price (dependant on supplier)
Jobs> Job ID (already generated from a previous system), contractor (person paying us to do job) job address, material delivery ticket numbers
On jobs I would also need to include materials and amounts used as well as generating costing's for each job. (hopefully using my materials and supplier tables) Sometimes we do works on the same job but distinguish between each 'phase' by the date the works were done, which would also need to be included.
Like I said any help will be appreciated, just want to make work a lot easier and I know that doing it on access is the way to go. Its just been a while since I built anything from scratch.
****update 14.50 06/03/14:
So I have been looking around and it seems what I actually want to do is merge a order management database with a contractors database to handle all aspects of the working. Such as holding information on contractors, materials used which i can then create reports for job costing's, material summaries for each job etc. But im still finding it difficult
Thanks in advance
R M Harper
Last edited: