You can actually start the customer account numbers at any number you want, maybe this should be a higher number by default.
If you want to alter the customer table, you can run this SQL command to start the number at 10000 for example: ALTER TABLE `customer` AUTO_INCREMENT = 10000 It may also be a better idea to use something like the customer email address as their account manager login instead of their account number... this is something to think about for future versions. Paul On 9/23/07, AJ Becker <[EMAIL PROTECTED]> wrote: > only reason i wanted to do this was for users to be able to log into there > accounts. Im not fond of low 2-3 digit account numbers to start.. makes it > look like you have no customer base. plus its another number they have to > remember to get to there account. > > ----- Original Message ----- > From: "Paul Yasi" <[EMAIL PROTECTED]> > To: "For users of CitrusDB discussion" > <citrusdb-users@lists.sourceforge.net> > Sent: Sunday, September 23, 2007 9:41 AM > Subject: Re: [Citrusdb-users] (no subject) > > > > It is not possible for citrus to change a customer's account number. > > Keeping the account number the same all the time is very important > > since it connects the customer with all their information. I would > > not use a phone number as their customer number, the customer may move > > and get a new phone number, or in a super rare case that number may be > > assigned to someone else. > > > > You can still search by their phone number, and upon a match it will > > take you right to that record. > > > > Paul > > > > On 9/23/07, AJ Becker <[EMAIL PROTECTED]> wrote: > >> > >> > >> is it possible to change a customers "customer number" ? Would like to > >> use > >> there phone number as their customer number. > >> ------------------------------------------------------------------------- > >> This SF.net email is sponsored by: Microsoft > >> Defy all challenges. Microsoft(R) Visual Studio 2005. > >> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > >> _______________________________________________ > >> Citrusdb-users mailing list > >> Citrusdb-users@lists.sourceforge.net > >> https://lists.sourceforge.net/lists/listinfo/citrusdb-users > >> > >> > > > > > > -- > > The CitrusDB Project | http://www.citrusdb.org > > Open Source Customer Care & Billing System > > > > ------------------------------------------------------------------------- > > This SF.net email is sponsored by: Microsoft > > Defy all challenges. Microsoft(R) Visual Studio 2005. > > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > > _______________________________________________ > > Citrusdb-users mailing list > > Citrusdb-users@lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/citrusdb-users > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2005. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > Citrusdb-users mailing list > Citrusdb-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/citrusdb-users > -- The CitrusDB Project | http://www.citrusdb.org Open Source Customer Care & Billing System ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ Citrusdb-users mailing list Citrusdb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/citrusdb-users
