lower level bill of materials (1 Viewer)

[rainbows]

i have hit a problem and i am not sure how to get out of it
below is a parts list for a product called.DC4573M1 this is a capacitor. if an order arrives for one of these i run a query that looks at the stock for these items and if any need ordering it will show me

the problem i have hit is take this item below from the list above i thought we would just buy this item complete. of which i am now being told mauybe we will want to buy the material ourselfs machine the parts and then send the out for plating

it consists of a procedure of

1. buy raw material say 3 mtrs
2 make bosses out of raw material say 20
3 electrically tin the boss say the same 20

not calling up 40 to be made

thanks steve







Product details Subform Product details Subform

Type	Stock Number	Material	Unit	ProductQty	DrawingNo	not reqd
Terminal	5036B9764MET	Terminal boss brass E/tin	ea	1​	9764 ref 13	0​

 

[CarlettoFed]

You should explain the procedure part better:

1. buy raw material say 3 mtrs
2 make bosses out of raw material say 20
3 electrically tin the boss say the same 20

not calling up 40 to be made

 

[rainbows]

this is the sales order for 1000 parts of the product i mention earlier which at this time calls up for 20 items from the BOM

I then run a query which tells me how many parts there are and what the quantites are

from this i then run an append query to tell me all the parts that need to be order as the stock is not sufficient

so i need to purchase 17line items
the problem i have is the bottom but one and 2 items need to have 3 proccess
but the material to make them which is a different stock no and make the part from that material which again is a different stock no before i can complete the parts called up. IE


Material Details 91 Days Material Details 91 Days

Type	StockNumber	Material
Terminal	5036B9764MET	Terminal boss brass E/tin

if i was just buying that part from a supplier i have no problem as it is upto them to but the material make the part unplated then plate it and send it to me


hope that helps

steve

 

[arnelgp]

fabrication from raw mat is another thing.
you can create an excel or another table/form for that.
then you monitor the date you sent it for fabrication.
on your material db, just add a Note/Remarks that is out
for fabrication.
when all is done, you write-off or add another comment
that all materials are received.

 

[CJ_London]

depends on how many levels you need to go down, if only one then take a look at the example db in this post

Solved - Need some advice for the design of Products table

@CJ_London Is this structure what you have in mind? And this is some data: If I may, I have a question: We have two orders. OrderPK 1 is an order for AP1234YA123. Is the order details correct for this order? Thanks again for all your help.

www.access-programmers.co.uk