My Situation: I have a list of products, some of which contain sub-assemblies, which are then listed in sub-data sheets. For ordering purporses, a user can go down the table and select which products are needed (using a boolean field). Since some products contain sub-assemblies, I am trying to figure out the best way to have these sub-assembly components automatically selected to prevent the user from forgetting to order necessary products. I have been brainstorming ways to use queries/filters/etc, but have not been able to get this to work properly. Any suggestions? If so, it would be extremely helpful to explicitly let me know the 'terminology' of what's needed, as that has been my main problem thus far. Thanks!