Record Relationships
Real world data is often interconnected. AnyDB allows you to create relationships between records, enabling complex data structures and workflows.
A AnyDB Record is a living, breathing piece of structured data that can be connected to other records.
This allows for a flexible and organized structure, enabling you to create complex relationships between different records.
No Relationship
Records can exist independently without any relationships. This is useful for standalone data that doesn't require linking to other records.
Linked Relationship
A record can simply be linked to another record just like a hyperlink on a website. This allows you to reference related information without duplicating data.
Example: A Insurance Claim record can link to a Customer Profile record.
To create link, in a cell inside the record, select the type as Reference. Then select the record you want to link to. Once linked, you can click the link to navigate to the related record.
Only records in the same database can be linked directly.
Attachment Relationship
A record can also be imagined as a folder that can contain other records as attachments. This allows you to create a set of grouped records that are logically related.
The easiest way to think of this is like folders in a file system that contains multiple files inside that folder.
Example: An Customer record might include:
- A Sales Contract record
- A Payment Information record
- Multiple Invoice records
Attached Records can in turn have their own attachments, creating a hierarchy of related records. In this case, the Invoice #2 record has a Quality Control record and a Shipping Confirmation record.
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. A file can also be connected to another file as well. (not that we are recommending this, but it is possible)
Parents and Child Records via Attachments
This type of attachment relationship allows the main record to be a parent record, with other records as child records. This is useful for organizing related information in a logical structure.
Child records attached to Multiple Parent Records
A child record can be attached to different parent records, allowing for flexible data organization. For example, a single Sales Contract record can be attached to Customer record and also to a Project record.
When a child is attached to multiple parents, it can be viewed in the context of each parent record. This allows for easy access to related information without duplication.
When a child is deleted from one parent record, it is still attached to the other parent record.