Search results

I think ive got it, would this work?? Thanks alot for any help tblproduct ---------------- ProdID ->pk Product (MOWER, STRIMMER, ROTOV'R,HEDGER,SCARIFIER) tblcomponents ------------------ CompID ->pk Component(Handle,cable,petrol tank.....etc) PartNo Price tblProductComponents...

Thanks Bob, I kinda understand, but not very well. Some products do share the same part number for the component. A handle for a mower has part number H10O and price of £4.50, for a strimmer it is part number H200 and price £4.50, for a hedger it is part number H100(SAME AS MOWER) and has price...

Hiya iam new one here, and fairly new with access. I got my self into a mess to what is proberly very simple to solve. I have 5 different products, which have 18 components for each product, each component has a part number and a price. Iam finding it difficult to arrange this data into tables...