> From: Greg Keys <firstname.lastname@example.org>
> In the process of entering our accounts in a new Emerald installation, we
> have run into the following problem:
> 1. An account is entered into Emerald (MBR and Subaccounts)
> 2. Another person (or the same, being very tired and loosing track)
> the same MBR again and saves it.
> 3. When the second person attempts to enter a subaccount they are
> that the login name is in use already.
> 4. The second person backs out and goes on to another customer.
> 5. When I go and search for last name Jones (or whatever) I find one
> but when I run a script such as:
> SELECT * FROM MasterAccounts
> WHERE LastName='Jones'
> I get 2 records listed. (Also, and what brought all this to my
> the phantom second MBR shows up in the Expired Accounts Reports)
> Any suggestions how to get rid of my Phantom MBR's ??