Hello Don,
Your idea would be to make a bill of material "on the fly", so to speak? This would still require an interface between the VBA part number interpreter and MACOLA input screens, wouldn't it? And this would require Flexibility?
At this point the client is considering the costs...