Hi everyone! I'm making a stock control database at work and I'm caught up on this one feature.
Each part we keep in stock for manufacturing has a part ID, PartRefID, which is formatted as 00-0000. The first two digits are the part type code. For instance, 11 is metalwork, 12 is hardware, 13 is...