A database system and method is presented that updates a retail transaction database for each transaction by extracting a name from a payment mechanism. Associations already made between the customer records, the transactions database, and the payment account database are used in conjunction with the extracted name to create additional associations between customers and transactions and between customers and payment accounts. In addition, new customer records can be created by searching demographic databases using the reverse append name and data associated with the transaction already in the database.