By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,528 Members | 1,324 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,528 IT Pros & Developers. It's quick & easy.

How do I create 100 records automatically

P: 1
HI,

I have 6 order book for issuing order numbers to suppliers.
Each has 100 unique numbers in it which I need to create in a trackable database to track our outgoing payments against each order number for each supplier.

Is there a way to create an order book that automatically creates 100 records with specified unique order numbers?

Does anyone know of some existing database similar that I can use as a starter?

thanks

Kevin
Sep 28 '06 #1
Share this Question
Share on Google+
1 Reply


100+
P: 143
You can either generate your own unique numbers(recommended) or use a custom autonumber(not recommended) You can limit the numbers by testing your Order No field against 100 and take some action when it reaches that limit.
Sep 29 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.