I am working on setting up a doweled drawer box and have a question regarding the machining for locks. With our existing drawer sub-assemblies we cut a 3 sided notch all the way through the sub-front of the drawer for the lock body, this cutout was driven by prompts in the drawer box sub-assembly. What I would like to do for the new doweled drawer box is to have the hardware token for the lock create the machining in the drawer sub-front. I want to filter the machining so that it only applies to the sub-fronts of the new drawer construction so I used the following for the Hardware token:

="PLINE[Sub Front Releif]*"&VLOOKUP(S!Bay_Position,G!LookUpTableBayDrawerBox,2,FALSE)&" Sub Front-M"

Note: the "-M" at the end is to differentiate this drawer sub-front from those of different construction.

This works fine as long as the cabinet only has one drawer, if it is a three drawer stack it only applies the sub-front machining to the bottom drawer (right cabinet in image). If I remove the bottom drawers it then applies the machining to the top drawer (left cabinet in image. I think the token is using the name filter for the first drawer box analyzed then using the same filter for the other boxes in the same cabinet.

I'm not sure if there is a tweak I can make to the formula to make this work or if I would be better off just listing all the possible drawer front names.

I look forward to hearing what the MV community comes up with.

Thanks.