Display each item in each row

I am new to coda.io coming from notion , I have three Tables

  1. Products
    ![image|690x230, 75%](upload://fiKx4Dwmmi0umXT1xIkfUofaEOq.png)
  2. Materials
    ![image|690x304, 75%](upload://bJq8no5fVaIu0bgLQisnaMgDpqo.png)
  3. Vendors
    ![image|690x386, 75%](upload://g45Prxef49SddrQcQf7CgGu4VQY.png)

as you can see in Materials table the Product Name showing the results of two product sepreated by comma , where as i wanted to display each row with each product instead of merging them , so that i can make the Material Order Date properly , right now if i assign a date to Product A800 for material Blister it will get assigned to A700,A800 both which i dont want. Is it possible in Coda ?

I want to display something similar to below , can someone help me give any suggestion or guide .

EDITED: I dont know why it does not allow me to post more then one image , any solution for that?

Hi @Chain_Reaction, welcome to the community.

I think the forum won’t let you post multiple images simply because you’re new.

If I get your problem right — in Coda you cannot display more rows than there are in a table. By that I mean, if you have 2 Materials, and each Material has 2 Products linked, there’s no way to automatically make a view that will have 4 rows for all material-product pairs.

What I’d suggest in your case is to make a separate “join” table e.g. Products and Materials where one row will link one product to one material, and you’ll have other columns relevant to the product-material pair. You’ll use this instead of linking Materials to Products directly. Then in your Materials and Products table you’ll rewrite your lookup formulas to pull relations from that join table and calculate some aggregated values if required.

That’s the Coda approach overall: bottom up. You design your data tables as granular as you need for your case, then aggregate when going up. I.e., the other way around than you’re asking for.

@Paul_Danyliuk
Thank you very much for taking time to reply to my post. I have try multiple times but i am not able to visualize your above method , is it possible if you can make a example and share with me . ?

Regards

Dear @Chain_Reaction

Please have a look at this basic example:

What’s more, if I understand correctly, as you build these tables, you can see the full context of each row, with subtables in the views of respective rows in each table. ie if I wanted to add to “Wood” things like “type of wood” and “vendor,” I can add see that detail in “table” row in the products table if I customize via the “customize Layout” feature and expand that lookup to display as a table, correct? And I can hide columns so that I only see in this embedded view what I’d like to see.

As I worked in Notion, there was nothing close to this level of detail and customization, which I really needed.

In fact I believe this is related to the problem @Paul_Danyliuk is helping me with over here:

I have not had a chance to try this embedding of subtables if we are talking about related hierarchical items from the same table, but hoping that will work more or less the same as with related items from different tables and lookups.