Example of Selecting Multiple Field Values

[SDT]

I have one table with 14 fields that each contain data that can be looked up in another table. For example the second table has a list of stock numbers and associated information about each. The first table contains the bills of materials with a separate field for each stock number.

Can I join these or perform a lookup such that all the stock number information applies to each of the BOM fields?

[asinha1991]

I am not able to visualize your exact requirement , can you explain with some sample data?

[anushree1]

Please check the concept of Mapping Load , that should help you meet the requirement

[SDT]

Looks like this might be the answer. I need to learn how to use it properly though.

[SDT]

Table 1 has 10 fields that each may or may not contain a value for "stock number".
I have a lookup table with all the stock numbers and their associated descriptions and costs. I want to connect the description and cost to every field in the first table that contains a stock number.