Dynamic Product Tags - or something like that?
So Im putting together an inventory reference/cost library for commonly-used products/materials for our construction projects. I intend to tie this library into our estimating tool once completed and want to find a way to better integrate stand-alone items vs. system components. You can see below in the far-left column that each row has it's own ITEM ID and, on the last two columns, you'll see whether that item is stand-alone or a system component. Id like to be able to find a way that IF an item is a system component, then when I click into the far-right row, it'll highlight the other items called out (IA0003, IA0004, IA0005). Im not sure if this is even possible or not but Im just looking for ways to better tie components together when they're part of a larger system. Does that make sense?