Using Base & numbering
October 21, 2009 4:10 PM Subscribe
Auto-generated numbers using Open Office base. Can it pick up where I left off?
Hi there. I'm trying to create a simple database for storing purchase orders. Right now everything is done in Excel and information has to be re-input in 4 different spreadsheets. So I am attempting to build something I can use.
Currently we're up to PO number 1525. Ideally I'd like to have Base start with order number 1526 & keep going from there. Is that possible? And I'd like that PO number to be the primary key to avoid dupes. Is that also possible? I've looked high and low and can't get it to auto-generate without getting errors when adding a new record.
Thanks!
Hi there. I'm trying to create a simple database for storing purchase orders. Right now everything is done in Excel and information has to be re-input in 4 different spreadsheets. So I am attempting to build something I can use.
Currently we're up to PO number 1525. Ideally I'd like to have Base start with order number 1526 & keep going from there. Is that possible? And I'd like that PO number to be the primary key to avoid dupes. Is that also possible? I've looked high and low and can't get it to auto-generate without getting errors when adding a new record.
Thanks!
Best answer: Going off this guide, it looks like the thing you want is:
alter table "Table1" alter column "ID" restart with 100
posted by 0xFCAF at 5:07 PM on October 21, 2009
alter table "Table1" alter column "ID" restart with 100
posted by 0xFCAF at 5:07 PM on October 21, 2009
Response by poster: Tell me you guys, what is it like being awesome? Thanks! I shall remember auto-incrementation for my next googling!
posted by Salmonberry at 10:18 AM on October 22, 2009
posted by Salmonberry at 10:18 AM on October 22, 2009
This thread is closed to new comments.
posted by zsazsa at 4:48 PM on October 21, 2009