BOM & Inventory Data Base

[ldiaz]

Hi all.

I just looking an example of BOM & Inveotry data base, if someone know any
web link please aswer me..

This what I want:
BOM=

IDPart ID Description Qtyper1 UOM


Inventory will have:

IDPartID Description QtyInStock QtyInProcess Balance

But I want to order QtyInProcess per Packets,
example: if one packets has 10 Bom wich each consume different materials,
but the sum of them need to appear in QtyInProcess .

please if anyone know or can help me I'll appreciate so much.

ldiaz

 

[Douglas J. Steele]

I haven't looked at it, but there's an example related to BOM at
http://www.mvps.org/access/modules/mdl0027.htm at "The Access Web"

 

[ldiaz]

Hi Douglas,,thanks to answer my question..but it does not work according what
I want,,anyway thank you so much ..if you know other website please let me
know..

my e-mail is:

[email protected]