A subtable (composition) creates closer relationships between tables.

When we want to write an invoice for consumption after a successful event, the invoice will likely consist of various items.

Here, a close connection is desired: If an invoice is deleted, it makes sense to also delete the items within it, as they are no longer needed. They were exclusively associated with this invoice.

 This close relationship between two tables is also called a composition.

Subtables are a powerful tool in the Ninox Builder!

 With them, you can build robust database systems that provide you with real-time access to your data at any time.

But we'll start a bit smaller and first guide you step-by-step through creating a subtable with a simple example...