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