Hello @lockarde
Challenging ... I have an idea in mind, using indeed relations, based on logic you can already have a look at, starting from the suggested technique link provided in article 32734
If you look at this suggested technique, the logic is a bit as follows: if Repeat Region finds a bulk item (asm.mbr.type) write AR (As Requested) in the quantity column (instead of rpt.qty). I am therefore wondering if this kind of logic can also be applied (in column 4 of your snapshot), based on material name identified in column 3 of your snapshot.
For this, I could do tests on my side (if above suggested technique won't provide enough level of details to try this approach by yourself), but I'm a bit afraid to not produce the same conditions and constraints you have already, and therefore maybe find a solution for my simple use case, which would however not work in your more complicated context.
=> Therefore, in order to ensure having a good starting point, would it be possible to share one of your drawings here in the comunity as base material to start investigations?
Of course, if you do it, ensure starting from an assembly with few components, and without sensitive (confidential) information. I guess I can start to investigate this even if the parts do not contain any geometry inside (all features deleted in part mode, keeping only material information inside), before backup and sharing purpose here.
=> If you do it, don't forget to close and erase everything afterwards to ensure you won't save a "reworked use case" leading in data loss otherwise.
Regards,
Serge
