MS Access - Summing the Price of Multiple Parts (Records) in Different Tables

[ban1k]

Greetings - I'm trying to get my head wrapped around this one; I may need just some general guidance, as I have light experience with Access.

I am creating a database that is meant to A) find all possible combinations of given parts/components, and then B) bundle together the price of each of those parts into one complete item with total price. So, to illustrate - I would combine the below 3 'Part' tables on the left into one 'complete item' table having just two columns/fields: 'Complete Item' & 'Complete Price'.

BasePart1	BasePart1_Price
WTL	100

<tbody>
</tbody>

Options1	Options1_Price
-ABC
-123	25

<tbody>
</tbody>

Options2	Options2_Price
-Z2	25
-Z3	50

<tbody>
</tbody>

COMPLETE-ITEM (All Combinations)	COMPLETE-PRICE
WTL-ABC <tbody> </tbody>	???
WTL-123 <tbody> </tbody>	???
WTL-ABC-Z2 <tbody> </tbody>	???
WTL-123-Z2 <tbody> </tbody>	???
WTL-ABC-Z3 <tbody> </tbody>	???
WTL-123-Z3 <tbody> </tbody>	???

<tbody>
</tbody>

I used the following Query to create all possible combinations ('Complete Item') table/field:

SELECT BasePart1.BasePart1 & Options1.Options1 & Options2.Options2 AS Complete-Item INTO Complete-Item
FROM BasePart1, Options1, Options2;

I greatly appreciate any insight or direction on solving and tying in the Complete Price portion of this to match up with the given items.

Thanks!