Where to start... food industry Access Database

[sdp_tws]

I work for a cheese packing company, and I'm starting to think of ways to control our stock in Access. I'm just struggling to picture where I am going to get started. I can picture in my head a design that includes the following tables:

• products
• transactions
• purchase orders
• production orders
• sales

Obviously also supplier, customer etc....

It must be able to deal with POs - and I'd like to receive stock against the POs. It must be able to deal with production - where one product, or many products must be taken out to add one in, according various formula.

Anyway, that is where I'd like to start. From there I will add whatever else I need but I'd like some advice where to start with this.

ie which tables will I need, how will they link together?

Thanks,
Ste

 

[HiTechCoach]

IMHO, inventory control is one of the most difficult tasks you can try to program (in any language)

See:
Inventory Control: Quantity on Hand

 

[gemma-the-husky]

one think that will make your project even harder is (presumably) traceability

i should imagine you will need some production batching mechanism to be able to identify which batch (and therefore which raw ingredients) applies to any given cheese.

this will add to the complexity of any solution

This is all going to be real hard - if you can find a ready made solution, I am sure it will be cheaper in the long run.

 

[sdp_tws]

IMHO, inventory control is one of the most difficult tasks you can try to program (in any language)

See:
Inventory Control: Quantity on Hand

Thanks for the link, that's a great help.

one think that will make your project even harder is (presumably) traceability

i should imagine you will need some production batching mechanism to be able to identify which batch (and therefore which raw ingredients) applies to any given cheese.

this will add to the complexity of any solution

This is all going to be real hard - if you can find a ready made solution, I am sure it will be cheaper in the long run.

That's true, batching is going to be necessary. This maybe very complex, although I will have a play around and see what I come up with.