

I know I need another table for customer and will probably need another table called orders for the stuff he works on but dont know what else i would need and dont know how to relate them all after from my understand I will be bringing in customers, and

I understand now that I will need 2 tables 1 for all the parts we use in the company and 1 decribing each part but in the table with all the parts will I have to have a column named Part_description or will that be carried in once I create the relationship? We use so under each category we have 3 or more things under it as well as the cost My manager orders parts through a company which are used in projects for the company.the parts we use are nipples, turn seals, heads, pipe, manifold, copper plumbing, pex plumbing, other, electrical/timer, miscellaneous.each part has different models Provided wiht on his new and my manager were just discussing how it would be nice to be organized and I know access is capable of doing this and have worked with Access 2003 but never with 07 which I find kind of confusing but let me give you Work on the project and will create a invoice.once the job is complete he then wants to make a job costing sheet which allows him to see how much he is spending and to work out how much he would like to charge customers based on the information he has been I am a student currently working for a irrigation company who has just started a new company working on residential work.customers call him in for estimates and if they approve the estimate he will I should give your more information and backround.
