We supply the same stock to various clients, who reference the stock according to their own item codes. We therefore need to add additional items codes to the stock item, but in a manner that we can capture more than one item code.
For example
=> Our item code : BAN-LGT-150
=> Client 1 item code : 145-009
=> Client 2 item code : B77-339
…
=> Client n item code : LIGHT-CREPE-150mm
The number of separate codes (“n” in the example above) is not known, so therefore it may not be practical to customise the form by adding additional fields. I can’t see any other way around this though.
Are there any other approaches to this?