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.