Re: Second Auto-increment

2003-06-11 Thread Becoming Digital
While I'm not sure I understand your intention, it seems to me like you need another table to hold your data. As Paul stated, AUTO_INCREMENT doesn't work this way. Edward Dudlik Becoming Digital www.becomingdigital.com - Original Message - From: "Q Zantos" <[EMAIL PROTECTED]> To: <[EMAI

Re: Second Auto-increment

2003-06-11 Thread Paul DuBois
At 19:43 -0700 6/11/03, Q Zantos wrote: I would like to auto-increment within an auto-incremented value. For example, if I have a rental agreement(auto-incremented) and that rental agreement becomes month-to-month. I was thinking that I would want to track the receipts as such: Contract # | Type