Search results

Hello everyone. I developed a database based on inventory control. It is same as Northwind database, the only difference is that here the inventory is in 3 locations. Now I want add a new feature on my database. Beside controlling inventory, it should show daily income as well. Whatever we sell...

Thanks Mr. jdraw, whenever you got time, please let me know, how to update the inventory after product is sold thanks. I will change the left join to inner join.

actually I got the idea from Northwind sample database, there they used left join. yeap you are right its Order Details form where we can enter customer's order. But I couldnt get any idea from Northwind sample database, how they update the inventory.

i have attached my database. I have made the customer order form, where I can enter their orders,, but I dont know how to update the inventory, means qty available in stock after sale of items. please help thanks

thanks Mr. Highandwild and Mr. Jdraw. Yes I have created a table which stores the movements of the product as per following. InternalTransactions: (id, ProductInvolved, QTY, From, To, Date). I have checked the attachments but still cant solve my problem. could you please tell me step by step...

Hello everyone, i am making a small database, almost half of that is complete,, and i am facing the following problem. There is one warehouse and two stores A and B respectively. The same product could be at warehouse, Store A and B. As per requirement some of the products are moved from...

I just want to know the following thing. suppose there is a product code 001. in warehouse : QTY=10 in Location A: QTY=3 in Location B: QTY=2 If company want to move 5 of the same product from warehouse to location 2,, it first should check where that much amount is available in warehouse and...

Thank you sir for the reply,, yes there is coding convention but with just product code a person cant identify the color and size. because each product code has different sizes and colors. the supplier id is just for the information, in case my be some day it become important. Actually the...

thank you for the reply. the answers to your questions are 1. Yes the same product could be in different locations as you showed in example. 2. Yes the single product could be sourced from different suppliers but the product could remain same but the same product could have different colors and...

thanks for the reply, but it didnt help me with the problem. i made following tables 1. Suppliers 2. Products 3. Inventory (supplier ID, Product ID, Location, QTY) 4. Locations and made some queries and forms for data entry. Just I dont know if they move product from one location to other how to...

There is one warehouse and two stores name A and B. as per need some of the products are moved from warehouse to stores and from stores to warehouse and between stores. Company wants the updated list, that how many of the products are in warehouse and stores. Please tell me how to do it, when...