Organizer Deluxe & Organizer Pro Help Center

Topic #:ID-1159

Ask a question, report problem, ..
    
Database Management FAQ : Database Fields : Automatically Generate Unique Numbers:

Related software (Read/Download) :
Organizer Deluxe Series
Organizer Pro Series
   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.
    create copy of invoice database
  • In the Create New Database window enter name in the Database Name box and description in the Database Description box. Click Ok.
    enter new database name and description
  • Click (Select) database (table) in the Create New Table From box. This structure will be used in the new database. Click OK.
    selet database to copy
  • New database (table) is created and listed in the Available Databases box. Click on the new database and click Load to open it.
    new database listed in the box



Part 2: how to modify data field type (regular text field to auto numbering text field):

  • On the File menu, click Designer.
    open database designer
  • In the Designer window click Create/Modify Data Fields Layout.
    create modify data fields layout
  • In the Select Database window select your database (in the example: Invoice Auto Numbering). Click Ok.
    select database
  • 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.
    select text auto incrementing data field type
  • 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.
    set options for auto numbering field
  • Enter Start From and/or Text Before end/or Text After values .... Click Ok.
    enter invoice auto numbering values
  • New field will generate invoice numbers automatically when new record is created.
    new field is ready will generate invoice numbers automatically
  

Related Topics ...
How to automatically generate unique id number for each record?





Related software (Read/Download) :
Organizer Deluxe Series
Organizer Pro Series
Invoice Software
Purchase Order Software




Copyright © PrimaSoft PC, Inc. All rights reserved.