Tecnologia, programação e muito Visual FoxPro.

quarta-feira, 4 de junho de 2014

[Access VBA Central] Bunching Information on Bill of Material (BOM)

 

So one day someone looked around and said, "Hey, some of these sets have components that are in other sets. Wouldn't it be great if we knew by looking at a set what % of components it shared with other sets?"


So for example, we have set A. Set A has b, c, d, e, f, g, h in it. Set B has c, e, g, and h in it. They want something that tells them what all of the % matches are for Set A among thousands (I think 3K sets) of sets.


Oh, and all of this is in one table so there's the set and the component.


I'm thinking that each set is going to have to be it's own table and that table will have to be checked against the BOM (bill of material) table that has all of the sets with their components in it and then that counts the # of components that match.


I'm just not sure if that's the correct way to go about it, or if I can make a copy of the BOM table and do it that way or if there's some easy way to do it.


Anyone has any experience with bunching like this?

__._,_.___

Posted by: joegkushner@yahoo.com
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)

.

__,_._,___

Nenhum comentário:

Arquivo do blog