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

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]BasePart1
[/TD]
[TD]BasePart1_Price
[/TD]
[/TR]
[TR]
[TD]WTL
[/TD]
[TD]100
[/TD]
[/TR]
</tbody>[/TABLE]






[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Options1
[/TD]
[TD]Options1_Price
[/TD]
[/TR]
[TR]
[TD]-ABC
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]-123
[/TD]
[TD]25
[/TD]
[/TR]
</tbody>[/TABLE]








[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Options2
[/TD]
[TD]Options2_Price
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]-Z2
[/TD]
[TD]25
[/TD]
[/TR]
[TR]
[TD]-Z3
[/TD]
[TD]50
[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]COMPLETE-ITEM (All Combinations)
[/TD]
[TD]COMPLETE-PRICE
[/TD]
[/TR]
[TR]
[TD]
[TABLE="width: 101"]
<tbody>[TR="class: grid"]
[TD]WTL-ABC
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]???
[/TD]
[/TR]
[TR]
[TD]
[TABLE="width: 101"]
<tbody>[TR="class: grid"]
[TD]WTL-123
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]???
[/TD]
[/TR]
[TR]
[TD]
[TABLE="width: 101"]
<tbody>[TR="class: grid"]
[TD]WTL-ABC-Z2
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]???
[/TD]
[/TR]
[TR]
[TD]
[TABLE="width: 101"]
<tbody>[TR="class: grid"]
[TD]WTL-123-Z2
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]???
[/TD]
[/TR]
[TR]
[TD]
[TABLE="width: 101"]
<tbody>[TR="class: grid"]
[TD]WTL-ABC-Z3
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]???
[/TD]
[/TR]
[TR]
[TD]
[TABLE="width: 101"]
<tbody>[TR="class: grid"]
[TD]WTL-123-Z3
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]???
[/TD]
[/TR]
</tbody>[/TABLE]


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!