I have created a database to handle orders / stock for dyeing yarns.
Background is we receive lots of different white yarns from company's to hold in stock. Each type of yarn will have different batches which need to be kept and recorded separately. These company's will then send us a 'dye to' order telling us which yarn and batch to use and how much and what colour to dye to.
The dyeing process actually reduces weight of yarn, therefore if customer wants 10kg we would dye 11kg (this is called greasy weight). When yarn has been dyed we record yarn, batch, colour, greasy weight, our dye lot no., net weight. We may then hold this coloured yarn for a while until we are ready to despatch. The despatch might be a complete order, or parts from different orders.
I need to be able to call up a 'white yarn stock' and 'coloured yarn stock' at any time, as well as outstanding orders, completed orders etc.
The database I have seems to work how I want, (I know its not designed perfectly but I am self-taught and have spent many hours with trial and error!), however I don't know best way to create packing list and hopefully stickers for the cartons. I have created a query which only shows yarn that has been dyed (because it has been given our dye lot no.) and from this a form - with a subform populating a advice note table to enter a carton no. and how kg of that particular yarn is in that particular carton, but from there I am a bit lost how to put that into a report that looks like a packing list (which I can print and hopefully at same time will print out a stciker for each box with what contents are inside).
I'm guessing I might have to do an update query??? Any help greatly appreciated.
Background is we receive lots of different white yarns from company's to hold in stock. Each type of yarn will have different batches which need to be kept and recorded separately. These company's will then send us a 'dye to' order telling us which yarn and batch to use and how much and what colour to dye to.
The dyeing process actually reduces weight of yarn, therefore if customer wants 10kg we would dye 11kg (this is called greasy weight). When yarn has been dyed we record yarn, batch, colour, greasy weight, our dye lot no., net weight. We may then hold this coloured yarn for a while until we are ready to despatch. The despatch might be a complete order, or parts from different orders.
I need to be able to call up a 'white yarn stock' and 'coloured yarn stock' at any time, as well as outstanding orders, completed orders etc.
The database I have seems to work how I want, (I know its not designed perfectly but I am self-taught and have spent many hours with trial and error!), however I don't know best way to create packing list and hopefully stickers for the cartons. I have created a query which only shows yarn that has been dyed (because it has been given our dye lot no.) and from this a form - with a subform populating a advice note table to enter a carton no. and how kg of that particular yarn is in that particular carton, but from there I am a bit lost how to put that into a report that looks like a packing list (which I can print and hopefully at same time will print out a stciker for each box with what contents are inside).
I'm guessing I might have to do an update query??? Any help greatly appreciated.