|
|
Question/Topic:
How to automatically generate unique numbers, codes (e.g.: po numbers, invoice numbers,..)
This topic explains:
1. how to create a copy of the existing database
2. how to modify data field type (regular text field to auto numbering text field)
Example is based on our Invoice database solution (deluxe version).
Part 1: how to create a copy of the existing database:
-
On the File menu, click Load Database.
-
In the Load Database window click New.
-
In the Create New Database window enter name in the Database Name box and description in the Database Description box. Click Ok.
-
Click (Select) database (table) in the Create New Table From box. This structure will be used in the new database. Click OK.
-
New database (table) is created and listed in the Available Databases box.
Click on the new database and click Load to open it.
Part 2: how to modify data field type (regular text field to auto numbering text field):
-
On the File menu, click Designer.
-
In the Designer window click Create/Modify Data Fields Layout.
-
In the Select Database window select your database (in the example: Invoice Auto Numbering). Click Ok.
-
The database layout is displayed (Field Layout Designer window). Click with right mouse button on the INVOICENR data field and select Change Field Type command.
-
In the Data Entry Control window select Text Auto-incrementing Field. Click Ok.
-
Click Save in the Field Layout Designer window.
-
Close Designer and open Organizer Deluxe.
-
On the File menu, click Load Database. Select the database (InvoiceAutoNr).
-
Click with the right mouse button on the modified field and select Options.
-
Enter Start From and/or Text Before end/or Text After values .... Click Ok.
-
New field will generate invoice numbers automatically when new record is created.
|
|