B
Bill
Hello,
I have two tables. The first table describes the actual contents of several
assemblies. The assemblies names are listed in the rows with the part
numbers of the possible contents going across the top. There is an "X" at
the intersection as appropriate.
The second table describes the requirements of several customers. Here the
customers are listed in the rows, witht the same part numbers going across
the top. Again, and "X" shows the part numbers the customer needs.
In effect I want to lay these tables over each other. For a given customer,
I want the assembly name(s) returned that contains all of the parts said
customer needs.
And for good measure, I would like to be able to specify either an exact
match of all required part numbers, such that no extra part numbers would be
included, and as well I would like to return the assembly names that contain
at least all the parts, if not extra others.
Is this an easy one?
Bill
I have two tables. The first table describes the actual contents of several
assemblies. The assemblies names are listed in the rows with the part
numbers of the possible contents going across the top. There is an "X" at
the intersection as appropriate.
The second table describes the requirements of several customers. Here the
customers are listed in the rows, witht the same part numbers going across
the top. Again, and "X" shows the part numbers the customer needs.
In effect I want to lay these tables over each other. For a given customer,
I want the assembly name(s) returned that contains all of the parts said
customer needs.
And for good measure, I would like to be able to specify either an exact
match of all required part numbers, such that no extra part numbers would be
included, and as well I would like to return the assembly names that contain
at least all the parts, if not extra others.
Is this an easy one?
Bill