Backend Database

How do I create relationships between data collections?

Fuzen supports relational data, so you can link records across different collections. This is the same concept as foreign keys in a traditional database or look

Fuzen supports relational data, so you can link records across different collections. This is the same concept as foreign keys in a traditional database or lookup fields in a spreadsheet.

Examples of relationships:

  • A Project is linked to a Customer
  • Multiple Tasks belong to one Project
  • An Invoice references a Quotation

How to set up relationships:

Tell the AI how the data should be connected when building or editing your app. For example: “Each project should be linked to a customer from the Customers collection” or “Tasks should have a lookup field to the Projects list.”

The AI will create a lookup field (also called a reference field) that lets users pick a related record. On the detail page, you can also show a related list — for example, showing all tasks under a specific project.

If you need help restructuring your data model, describe the full data structure to the AI and it will suggest how to organize the collections and relationships.

Related articles