BOMs. help.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all comunity.

I want to make a Data base to calculate multiples BOMs, my BOMs contain.

Part ID: is the name of product and this have:

RM-PartNumber QtyPer U/M
FAV-0014522-BKA 1.457 YD
MSO3030-1 1 EA
ZIP-0000025-BKA 2.5 YD

but also I want to have an history of each BOM calculated, each BOM will
have a Order Name as reference, for example I have an Order asking 5 Product,
these five Products are Five part ID asking different material each one,

I have downloaded BOMs as example from Internet but it does not work like
what I want..

can anybody help me to do this, any comments will be great.


Thank you so much for your help, any comments will be appreciated

ldiaz
 
You need to create another table that will store all the fields that
make up your BOM transactions. Upon completion of our BOM, have an
append query copy the appropriate transactions.
 
Back
Top