A large private bank issued equity shares & retail bonds in tranches resulting in creation of a large data base of over six million accounts which were grouped in numerous series and each series in turn has many categories depending on the features of the scheme. The real challenge was to segregate the incoming documents from the investors and identify their instructions/complaints before processing these transactions in the system. The solution suggested was to create a combined database in the front end for numerous series along with introduction of code types for each type of instruction/complaint wherein a particular transaction irrespective of whether it pertains to single series or multiple series or instructions or complaints gets inwarded into the combined database and subsequently gets automatically transmitted to the respective database for processing.