Help with my database please

[chr1stoper1]

Hi I have a database which I have built for use at work. The general gist of it is I can search for parts by detail number by what the parts are made of and the mould number that makes the part.


I have come across a problem most parts are made by one mould but some high volume parts have two moulds all the moulds have a unique number.
Now to my problem, in one table I have the information mould 1 and another column for duplicate mould.
Now when I search it will find mould 1 and show that it has a duplicate but I would like it to return the same if I type in the number of the duplicate tool, this is a problem because the primary key is the part detail number and both tools make the same part.
Is this achievable ? Thanks for reading and I hope this makes sence

[ranman256]

You need 3 tables,
parts. (Uniq)
moulds (uniq)
and a PartMolds. This is the child table to a 1-many relationship of parts (master) to (child) PartMolds.

partMolds fields:
partid
mouldID

so 1 part can have many molds.

[chr1stoper1]

Thanks buddy will give it a try