Question/Topic: How to create a duplicate database ?
How to create a new database with the same structure as the old one?
Create a new, empty database, with data fields and layout imported from the existing database.
On the File menu, click Load Database.
- In the Load Database window click New (A)
- In the Create New Database window enter Database Name (B) and Database Description (C). Click OK
- In the Create New Table From (E) select the source database. Click OK.
- New database with the same structure is created. Select the database (E) and click Load.
How to automatically generate unique numbers, codes (e.g.: po numbers, invoice numbers,..)