Skip to main content

Hi,

I'm new to miro and playing around with the "Table" tool.

Is it possible to create 1:n or n:m relations between two tables?

1:n relations:

Say table 1 is called "Manufacturers" and table 2 is called "Car Models". I would like to relate the car model "911" in table 2 to the manufacturer "Porsche" in table 1. I.e. basically having a field in table 2 of type select but with options that are fed by table 1. (or to use database wording: foreign key relations)

m:n relations:

Having a field in table 1 of type select so that I can select for manufacturer “Ford” the models “Model T”, “Mustang”, “F-150”. I.e. a multi-select field that is fed by table 2.

Is this possible with the "Table" tool? If not: What other options are available to somehow model this scenario?

 

Hi,

I'm new to miro and playing around with the "Table" tool.

Is it possible to create 1:n or n:m relations between two tables?

1:n relations:

Say table 1 is called "Manufacturers" and table 2 is called "Car Models". I would like to relate the car model "911" in table 2 to the manufacturer "Porsche" in table 1. I.e. basically having a field in table 2 of type select but with options that are fed by table 1. (or to use database wording: foreign key relations)

m:n relations:

Having a field in table 1 of type select so that I can select for manufacturer “Ford” the models “Model T”, “Mustang”, “F-150”. I.e. a multi-select field that is fed by table 2.

Is this possible with the "Table" tool? If not: What other options are available to somehow model this scenario?

 

Miro's "Table" tool doesn’t support direct 1:n or n:m relationships like a database would. You can create select or multi-select fields, but they don’t dynamically link tables in the way you’re describing. However, you can manually populate a field in Table 2 with values from Table 1, or vice versa.

For n:m relationships, you could use separate tables for linking or rely on visual connectors. Think of it like setting up structures in Minecraft where you connect blocks in creative ways to represent relationships, even if there’s no built-in automatic linking.

For more advanced database-like features, you might want to explore Miro integrations with tools like Airtable or Notion.

Hi ​@Tobias Schleinkofer 

 

Welcome to Miro! 😊

 

Great question—currently, the Table tool doesn’t support direct 1:n or m:n relationships like a database would. You can manually populate fields to reflect these connections, but they won’t dynamically update based on another table’s data.

 

For possible workarounds:

  • Use connectors to visually represent relationships between tables.
  • Manually populate dropdowns or multi-select fields to simulate foreign key relationships.
  • Explore integrations with external tools like Airtable or Notion for more database-like functionality.

If this is something you’d like to see in Miro, I encourage you to share your feedback via our Wish List here. Let us know if you need any other suggestions! 

Reply


🚨 Last chance for early-bird tickets to Canvas 25! 🚨

Terms & Conditions