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?
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.
