I have a batch of products that has one unique number (PK) but this needs to be split into several smaller batches but still be linked to the original batch(PK) for tracking purposes. so say a batch of 20 items is split into 4 = 5 batches. can i have the original (PK) eg: 001 and then the second of this split batch being 001A and so on.
How would i go about doing this and how would it be setup? thanks in advance.