BOM Info question

Hi all.

I'm creating a DataBase for BOMs calculation and History info.

I have a TableNamed tbl_BOM with this info.
autonumber &

Base_ID Part_ID DESCRIPTION QTY_C
UOM
S-YSC2-40 LAH-SILVR01 -B- Panel label silver 2 EA
S-YSC2-40 LAH-SILVR02 -B- Panel label Gold 2.5 YD
S-YSC2-40 LAH-SILVR05 -B- Panel label Plastic 2.5 SF
S-YSC2-40 LAH-SILVR06 -B- Panel label Nomex 1 EA
S-YSC2-35 LAH-SILVR05 -B- Panel label Plastic 2.3 SF
S-YSC2-35 LAH-SILVR06 -B- Panel label Nomex 25 EA


this information is Filtered in a subform using Base_ID then if I select an
Item like: S-YSC2-40
all material that has this BOM will show in the subform, like:
Base_ID Part_ID DESCRIPTION QTY_C
UOM
S-YSC2-40 LAH-SILVR01 -B- Panel label silver 2 EA
S-YSC2-40 LAH-SILVR02 -B- Panel label Gold 2.5 YD
S-YSC2-40 LAH-SILVR05 -B- Panel label Plastic 2.5 SF
S-YSC2-40 LAH-SILVR06 -B- Panel label Nomex 1 EA

the Main Form where is located the subform has field like:
Autonumber &
PacKName ActiveYN Base_ID ActiveYN DateofSummary WhoDid QTY

then I have a Button to append Datas from the SUBFORM to another table named:
tbl_SummaryBOM
where it has field like:
Autonumber &
Base_IDS Part_IDS DESCRIPTIONS QTY_CS
UOMS
S-YSC2-40 LAH-SILVR01 -B- Panel label silver 2 EA
S-YSC2-40 LAH-SILVR02 -B- Panel label Gold 2.5 YD
S-YSC2-40 LAH-SILVR05 -B- Panel label Plastic 2.5 SF
S-YSC2-40 LAH-SILVR06 -B- Panel label Nomex 1 EA

But QTY_CS will show the Value of the SUBFORM * QTY showed in the FORM.

The question is:
Is there another option to make this? because tbl_SummaryBOM will have many
datas since each BOM has maybe 30 rows and it will be calculated many times.

Thanks.
if anyone has some similiar DB I will appreciate so much your help .



Lorenzo DÃ*az
Cad Technician