Hi OBP
now have a list of all BOM
Many Thanks
Nick
Hi OBP
now have a list of all BOM
Many Thanks
Nick
Experience is something you don't get until just after you need it.
Nick, how does this BOM fit in with the SQL table?
Do you need to see Old Rolls on the main data form, or can they go on a History form?
Hi OBPOriginally Posted by OBP
old rolls can go in history form yes, BOM is all rolls that have any BOM associated with them , what i do is a vlookup at moment to bom table and when i enter rolls into MILL it give me a list and then i print it out and order from Stores
Hope this helps
Nick
Experience is something you don't get until just after you need it.
So is the BOM table going to be in the Access database as well?
Yes OBP it will, it should never change unless a new order comes in and it requires BOMOriginally Posted by OBP
Thanks
Nick
Experience is something you don't get until just after you need it.
Nick, I am pulling out the Part Numbers from the BOM, should the same Part number have different descriptions?
Like
CW 6172DDK = KEY Ref:CW 6172DDK & CW 6172DDK DUMMY KEY
Hi OBPOriginally Posted by OBP
CW No would be 6172
Drawing No would be CW6172
Part No would be CW6172DDK
Type would be DUMMY KEY
Hope This helps
Thanks
Nick
Experience is something you don't get until just after you need it.
So should the table be laid out like that?
As at the moment you have a lot of parts with different descriptions like the one that I have shown.
But we have another big problem.
The new BOM table has 8907 Rolls that are not in the SQL table. Should they be in there as well or are they old Information?
Hi OBPOriginally Posted by OBP
yes if the BOM table can be laid out like that, and yes they should all be in the SQL table too
Thanks
Nick
Experience is something you don't get until just after you need it.
Nick, I think the database is going to be too large to post on here, so I will need your email address, can you private mail it to me?
I need for you to have a look at it and also do a shedfull of work on it.
All those Rolls in the BOM that are not in the SQL need all the other data added, like Customer, Delivery Terms, WORef, Grades, areas etc etc.