My first Database, struggling a bit

[ravihotwok]

Hello peeps,



ive just started to create data base, ive been looking on youtube at the tutorials and managed to get my head around some of it. basically here is what in trying to so.

We use a lot of different pipes for our work for different projects, I have inputed some basic data into a table called item description, this conotains the pipe detail (diameter/type) supplier and length its supplied in.

What I want to do is create a form which we can populate with all the defferent types of pipe in one of our jobs. I want to create a form for adding new parts to the table so its more user friendly to other users as opposed to using the table itself.

Also when we are listing down the different pipes and fitting within one of our jobs there may be a few duplicated for example there may be 3 90deg bends.

Can I create a report once the form has been populated with all the different items which groups the duplicates together and totals them up?

Ideally the final report will list each different part, and the quantity/length required.

Hope this makes sense, any help would be great

rav

[pdebaets]

You could gain a lot by starting with the orders template: http://office.microsoft.com/en-us/te...001018547.aspx