I have two tables I need to relate. In table A, we have part#1, part#2, and part#3. In table B, we just have part#. How should I go about connecting these tables? Table A has 3 different part fields in case the user needs to use 3 parts. Table B has the part#, part description, and Qty on hand.