Hi
I work in a small company warehousing yarns ready to be woven into fabric. I have created a simple stock database, and can enter customer orders with an estimate of all different yarns required for each fabric. (not an exact science unfortunately) So i have queries/reports of total yarn in stock, total yarn required and total free yarn.
The yarn is sent off-site to be made into fabric and I would like to be able to create a form that has a drop down box to chose a job no and then populates fields customer, fabric, yarn, warp colour, kg, weft colour kg but then have new boxes with actual yarn sent (we always send more than estimate) and date. Was wondering how best to do this part. I would also like to run an update query so that once I have entered the date here I can generate other reports to show stock off-site and total stock on-site - and also if there is a date not to show the job no in drop down box.
There is a lot more I want to do after this - ie once fabric is woven, update stock to take yarn off completely, and then a form to add any yarn returns back on stock (against the order they were sent for so I can monitor how good the initial estimate was) - but hopefully would be able to work this out...
Thank you
I work in a small company warehousing yarns ready to be woven into fabric. I have created a simple stock database, and can enter customer orders with an estimate of all different yarns required for each fabric. (not an exact science unfortunately) So i have queries/reports of total yarn in stock, total yarn required and total free yarn.
The yarn is sent off-site to be made into fabric and I would like to be able to create a form that has a drop down box to chose a job no and then populates fields customer, fabric, yarn, warp colour, kg, weft colour kg but then have new boxes with actual yarn sent (we always send more than estimate) and date. Was wondering how best to do this part. I would also like to run an update query so that once I have entered the date here I can generate other reports to show stock off-site and total stock on-site - and also if there is a date not to show the job no in drop down box.
There is a lot more I want to do after this - ie once fabric is woven, update stock to take yarn off completely, and then a form to add any yarn returns back on stock (against the order they were sent for so I can monitor how good the initial estimate was) - but hopefully would be able to work this out...
Thank you