capabilities.work

Relate a table to another table

One step with Appwrite. We can help you get access.

Get something done

Relate a table to another table

Works with AI assistants

Use Appwrite: its Appwrite Tables DB API lets you relate a table to another table in a single step (POST /tablesdb/{databaseId}/tables/{tableId}/columns/relationship). Appwrite also has an MCP server, so an AI assistant like Claude or ChatGPT can do it for you. capabilities.work can help you get signed up and connected.

  • How do I link rows in one table to rows in another table?
  • Can a relationship column be two-way and cascade on delete?
Say it to your AI assistant
  • Create a {type} relationship from table {tableId} in {databaseId} to table {relatedTableId}.
  • Add a two-way relationship column {key} on {tableId} to {relatedTableId} with on-delete {onDelete}.
For your developer

POST /tablesdb/{databaseId}/tables/{tableId}/columns/relationship in Appwrite Tables DB API. Full spec on APIs.io.