How would you recommend including the Location of each part? Example: we have over 3,000 parts and our current location labeling scheme is Warehouse, Aisle, Section, Shelf. So Part001 is in location 1, 1, A, 1 and Part501 is in 1, CAB A. (CAB for cabinet.) Thanks and I enjoy your tutorials!
Hi! Can you help me about making an database for Firearms inventory? What tables that should put in? or what are your advises for my project dtbase? Thank you
Hi! I am learning a lot from your channel. My mother-in-law has a food product manufacturing business (e.g. poprice & popcorn) and I am interested to start a draft. Do you have a similar video of this? Please note that employees are paid according to the: 1. number of finish product produced. 2. qty of raw material (rice, sugar) cooked. I'll be glad for your response. More power.
Hi, i think i like this video. But i will like to see how to create the relationship and a rough design of Inventory that can have serial numbers of items Especially when the same item has more than one Thank you in advance
Dear Sir, Thanks for publishing & sharing the such precious information. i am designing a program for our spare parts shop. i have a table "Master Inventory Record which is consist of 249 line items/part numbers. I have column for On Hand (OH)and Column number 2 is for new receipt. what i want that my new receipt should be added in OH and qty on order of column No 3 become zero. above to this, i want that the qty should be also add in qty Received after next receiving order, Thanks
![Kodak Black - Catch Fire [Official Music Video]](http://i.ytimg.com/vi/A4ch-olIuZo/mqdefault.jpg)
thumbs up to the best teacher as always. thanks Richard
Thank you! Thank you very much. I have a final class project due tomorrow and this has been very helpful. As have all of your other tutorials! Thanks
Welcome. How'd that project go?
How would you recommend including the Location of each part? Example: we have over 3,000 parts and our current location labeling scheme is Warehouse, Aisle, Section, Shelf. So Part001 is in location 1, 1, A, 1 and Part501 is in 1, CAB A. (CAB for cabinet.)
Thanks and I enjoy your tutorials!
+bgray79 how about just a separate LocationID field where you can link to a LocationT table?
Thank u so much now i can finish my project
My pleasure.
Hi! Can you help me about making an database for Firearms inventory? What tables that should put in? or what are your advises for my project dtbase? Thank you
What differences would firearms have from a normal parts inventory?
Hi! I am learning a lot from your channel. My mother-in-law has a food product manufacturing business (e.g. poprice & popcorn) and I am interested to start a draft. Do you have a similar video of this? Please note that employees are paid according to the: 1. number of finish product produced. 2. qty of raw material (rice, sugar) cooked.
I'll be glad for your response. More power.
Nope, sorry.
Who the hell has disliked such a helpfull video/clip
Haha. I know, right? Those damn kids!
Hi, i think i like this video. But i will like to see how to create the relationship and a rough design of Inventory that can have serial numbers of items
Especially when the same item has more than one
Thank you in advance
+John Chukwudi You would use a second table to track the individual units of a particular item type.
Dear Sir,
Thanks for publishing & sharing the such precious information. i am designing a program for our spare parts shop. i have a table "Master Inventory Record which is consist of 249 line items/part numbers. I have column for On Hand (OH)and Column number 2 is for new receipt. what i want that my new receipt should be added in OH and qty on order of column No 3 become zero. above to this, i want that the qty should be also add in qty Received after next receiving order, Thanks
Mind to share me database?
599cd.com/Inventory