Hi to all,

I have a somewhat interesting problem that needs solving. I have built a
system to keep track items that are booked in for repairs. These items do
not have serial number. Each item is tagged and the TAGNO is made up of the
following. YEAR + JOBNO. This is all fine. The problem is that the client
can bring in two identicle articles on the same job and when this happens I
need to append a "A" or "B" to the TAGNO. eg 2004/1029A. The A or B will
only be added if item is duplicated.

Any ideas of how to add this if the scenario occurs.

Tnaks
Elmo