Adding a ',' (comma) while input data into a field

[Shuja]

Hello Everybody,

The requirement is to receive multiple items from a purchase order.

Let's say, we have a purchase order table which has "purchase order number", "serial number", and "received" fields.

When the order is ready, vendor sends us a confirmation and uploads our purchase order table with "purchase order number" and "serial number" data in this table. Then the vendor ships the order to us.

When we receive the shipment we know which purchase order it is. But now we have to receive each of the items present in that purchase order. So, to receive individual items on the purchase order, we want to scan the serial number off of each box. Each of these serial number should go to the purchase order table, finds the specific purchase order number and matches the serial number. If serial number is found in that purchase order then the system will add 'Received' in the "received" filed of that serial number record.

Now while scanning different serial numbers there is a need to automatically add a ',' (Comma) after scanning each serial number.

Currently I am trying to achieve this on a catalog item. But if any other method is also acceptable.

Need help in this.

Thanks in advance.