Orders Management Database Template

G

Guest

I found this template ery usefull but I'd like to acommodate it to my needs.
How do I reset the counts on customer id, employee id, order id? You
see...the template already has a few examples of customers, orders, employees
and so with their IDs, but I'd like to delete them all and start from ID 1.
Putting that on the side, the template is just great. Good job !!!
 
T

tina

you can delete the records and then compact the database. assuming that
these are Autonumber fields, that should take care of it. note that if those
ID values are never seen by the user (as is most likely if they are
Autonumber fields), then it really makes no difference what the "starting"
values are.

ht
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Orders Management Database in Microsoft Access 1
Help Customizing Project Management Database Template 5
Stumped - linking customers into orders - PLEASE read, I need to get this fixed!! 6
Stumped - linking customers into orders -interface to match relations - existing vs. new cust. 4
create queries 7
Stuck, Oredering form, Any ideas? 25
Database used to make work orders and purchase orders 1
Northwind as an example 8

Top