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.
Relationship Types
- A AnyDB record can have many other records attached to it as related child records.
- A single AnyDB record in turn can be attached to mulitple records
- 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.