Skip to main content

Relationships Between Records

Real-world data is rarely isolated.

Example: An Invoice document might include:

  • A Customer (linked as parent)
  • Multiple Line Items (child records)

AnyDB allows records to be linked in flexible relationships.

Linked Record Concept

Relationship Types​

  • A AnyDB record can have many other records attached to it as related child records.

Linked Record Concept

  • A single AnyDB record in turn can be attached to mulitple records

Linked Record Concept

  • A record can also link to other records via powerful formulas. Thus a record can be built from many other records itself. (Composition)

Multi-Parent Support:
A single record can be linked to multiple parents, enabling powerful cross-referencing and business process tracking.

Pages, Files and Folders in AnyDB:
In AnyDB, pages, files, folders work and behave like records. They can be linked to other records, allowing for a flexible and organized structure. This means tha a file can be connected to a record and also be connected to another record as well.

Any level of Records and files can be connected together