N
Nick Bradbury
Hi
I have a database to call off inventory for customer orders, calculate
reuirements etc. My problem is how to structure the tables to accomodate the
same components from different suppliers. For example I have an order for
Item A, Item A has two components on the bill of material
2 x FJJAC45BOXX
3 x FCRFWHOSXX
Next week I get another order for Item A but this time the first item is
only available from a different supplier and thus has a different code
2 x FJJAC45CRXX
3 x FCRFRWHOSXX
The way that the code is structured is that the first 7 digits identify the
item and the last four identify the supplier and counry of origin how can I
organise the table to give me the option of picking the correct part without
having lots of different BOMs for each item. I need to have traceability for
all components.
Many thanks
Nick
I have a database to call off inventory for customer orders, calculate
reuirements etc. My problem is how to structure the tables to accomodate the
same components from different suppliers. For example I have an order for
Item A, Item A has two components on the bill of material
2 x FJJAC45BOXX
3 x FCRFWHOSXX
Next week I get another order for Item A but this time the first item is
only available from a different supplier and thus has a different code
2 x FJJAC45CRXX
3 x FCRFRWHOSXX
The way that the code is structured is that the first 7 digits identify the
item and the last four identify the supplier and counry of origin how can I
organise the table to give me the option of picking the correct part without
having lots of different BOMs for each item. I need to have traceability for
all components.
Many thanks
Nick