Selasa, 24 Maret 2015

[MS_AccessPros] Creating Unique Collection Code

 

Hi All,
        I have been assigned a new task  to generate and enter a unique collection code separately for each client, for each new consignment while entering data in form "Collection Voucher".

Logic for generating this code is that when this code is generated for clients new consignment, this code will be passed him and then he will pass this code  to his authorized person at destination and that person will show or give this code to company's responsible person to deliver him the cargo.

The pattern for this code should be like starts with "ClientCIN"  then two OR Three alphabets ending with two digits.

Is it necessary to generate this code in form "Collection Voucher" or some working is to be done in some other form before and then putting that code in form "Collection Voucher" ?

Help required please.
Khalid
 

__._,_.___

Posted by: Khalid Tanweer <khalidtanweerburrah@yahoo.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)

.

__,_._,___

Tidak ada komentar:

Posting Komentar