Re: [Emerald] CustomerID

Dale E. Reed Jr. ( (no email) )
Wed, 24 Feb 1999 11:03:44 -0800

Annabel Mwansa wrote:
> We imported accounting information into Emerald. In the process a large
> chunk of Customerid numbers were skipped between the last record
> physically entered and those imported.
> We would like to maintain a clean list of customerid's and would
> therefore like to find a way of reassigning these ID's to the MBRs and
> other related records.
> How do I change the CustomerID in all related tables?

You can't that easily. I really wouldn't worry about it. There
isn't anything bad about having CustomerID numbers spread out. They
are just unique identifiers in the datavase.


Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc.

For more information about this list, including removal,please see