Altering starting order number

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   A client wishes me to alter the beginning Order number (PCv3, Access db).  
I figured I could turn off auto-increment for the Order table, use a SQL query to insert a higher number into that field, and then re-establish auto-increment.  Unfortunately, MS-Access won't allow this and reports there is a relationship on that column.
Any way to do this?
Thanks,
Greg

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
Greg Dinger Members Profile Send Private Message Find Members Posts Add to Buddy List Certified ProductCart Developers Joined: 23-September-2006 Location: United States Status: Offline Points: 238	Post Options Post Reply Quote Greg Dinger Report Post Thanks(0) Quote Reply Topic: Altering starting order number Posted: 08-June-2007 at 12:01pm
	A client wishes me to alter the beginning Order number (PCv3, Access db). I figured I could turn off auto-increment for the Order table, use a SQL query to insert a higher number into that field, and then re-establish auto-increment. Unfortunately, MS-Access won't allow this and reports there is a relationship on that column. Any way to do this? Thanks, Greg

netprofits Members Profile Send Private Message Find Members Posts Add to Buddy List Certified ProductCart Developers Joined: 05-January-2006 Location: United States Status: Offline Points: 22	Post Options Post Reply Quote netprofits Report Post Thanks(0) Quote Reply Posted: 08-June-2007 at 12:25pm
	Hi Greg, just go to the control panel, Settings \| Store Settings then click the Order & Customer Related tab. Change the setting for order # increase. There is also a setting for Customer # increase. For more details see the PC user's guide.
	NetProfits Internet Consulting Certified ProductCart Developer Our Site

Greg Dinger Members Profile Send Private Message Find Members Posts Add to Buddy List Certified ProductCart Developers Joined: 23-September-2006 Location: United States Status: Offline Points: 238	Post Options Post Reply Quote Greg Dinger Report Post Thanks(0) Quote Reply Posted: 08-June-2007 at 12:49pm
	Wow... Thank you. I continue to be simply amazed at the foresight and numerous options built into ProductCart.