Database Homepage

When you open a database, you will get to the database homepage.

a) Click on the menu button to get more options. From here you can save databases as an archive. The resulting .ninox file can be shared easily and opened with all Ninox Versions. The second option is to duplicate the database. This might be handy when you want to change the store location from “local” to “iCloud” for example. You also can rename databases. From here you can leave the database and return to the home screen, as well.

b) You can reach the database homepage anytime by tapping on the home icon.

c) Opens the Calendar.

d) Opens the Search page.

e) Tap on the X to close the table and hide it from the menu.

The second row is composed of several tabs. Tap on one to open it.

f) The wrench icon activates or deactivates the administration mode. This mode offers you several tools to administer your database. For example, you can create a table, modify forms and adjust settings. As long as the wrench icon is red, the administration mode is active.

The second row is composed of several tabs. Tap on one to open it.

g) Displays all tables in the database. Activate the administration mode and you can create new tables here.

h) The data model provides you with a better overview of the tables and their relations, especially in the case of more complex databases.

i) Opens the options menu.

All tables are listed below the navigation bar.

j) Tap on a table to open it.

k) This table has one or many sub tables. Click on the menu button to see and open the subtables.

l) Opens the dialogue to create a new table.

m) Opens the template library for tables. As opposed to database templates, you can incorporate table templates into existing databases.

n) Provides different operations for data import.

o) Provides different operations for data export.

2.2.1  Datamodel

The data model provides you with an overview of the tables and their relations (table references). That will be useful, when you work with a lot of tables with multiple references. You have access to the data model only when the administration

mode is activated.

_DatamodelMG

a) Opens the data model.

b) Opens the dialogue to create a new table.

c) A table is shown as a black-framed rectangle with rounded corners. Tap on a table to open the dialogue to modify the table definiton.

d) Table references are shown as an arrow. In this example, a table reference has been created from

Invoice

to

Client

– that is, a reference field has been generated in the

Invoice

table definition.

The direction of the arrow means that one customer can have many invoices. However, one invoice only belongs to one customer.

e) The table

Invoice

contains a subtable:

Invoice Item

.

f) Subtables are shown integrated into their supertable. A subtable is created by referencing it to the supertable and activating the option

Composition

.

In this example, a table reference has been created in the table

Invoice element

with the table

Invoice

selecting the option

Composition

(in more options).

This definition has several consequences:

  1. Different presentation in the data model.
  2. Subtables are not listed on the database homepage.
  3. As soon as a data record is deleted from the supertable, all linked data in the subtable is deleted as well.
  4. The form of the supertable does not provide the operation

    Search and add

    (magnifier icon) for the subtable.
  5. The form of the subtable does not provide the operation

    remove reference

    .

See chapter

Table References

for further details about the different kinds of relations between tables and how to use them successfully.

2.2.2  Options

The option page provides general settings for the active database.

_Options

a) Opens the options page.

Printing Options

b) Change the default font-size for the print layout.

c) Choose the printing output: PDF or HTML.

Style Options

d) Tap here to upload your own background image from your photo collection. Please keep in mind that background images might affect the performance of older devices.

e) Alternatively, you can choose from the pre-defined color schemes. Those backgrounds are more performance-friendly.