Re: [Emerald] CustomerID

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

Messages sorted by: [ date ][ thread ][ subject ][ author ]
Previous message: Dale E. Reed Jr.: "Re: [Emerald] Run-time error '10' when creating invoices"
Next message: Ronnie D. Franklin: "RE: [Emerald] Form-Id"
Maybe in reply to: Annabel Mwansa: "[Emerald] CustomerID"

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. www.iea-software.com

For more information about this list, including removal,please see http://www.iea-software.com/maillist.html

Previous message: Dale E. Reed Jr.: "Re: [Emerald] Run-time error '10' when creating invoices"
Next message: Ronnie D. Franklin: "RE: [Emerald] Form-Id"
Maybe in reply to: Annabel Mwansa: "[Emerald] CustomerID"