Hello folks
I am having trouble with an Inventory DB I am building. I know the general theory of calculating inv on hand as opposed to storing it, but this is the issue:
I deal with a book buying company, and as such, there is a pool of over 500,000 records that contains book information. this is tblAT. I also have tblInv which contains ISBN, Quantity, and Condition of the book. I have a query that pulls records from both tables, and assigns a SKU which is a combination of 4 letters of Author, 4 Letters of Title, last 4 digits of ISBN, and a condition id number. I have built a form which enters this info, and a subform which displays the individual records in the above query. The purpose is to display the recent records that were just entered in the subform so that the user can easily spot any data entry errors.
I want to keep a summed quantity of each sku (each book will have 4 sku's which are calculated in the aforementioned query, as we use 4 different condition designators). I wish to use a form to select books for my warehouse guys to pull from the shelves and adjust my quantity on hand. The question is, what is the best method to accomplish this. I will have a checkbox and quantity, then update query to subtract QSold from QonHand.
I thought about a make-table query on the OnClose event proc, but I'm not sure thats the best idea, because the make-table could take too long to run, plus multiple users will be entering info at once.
If anyone has any ideas, please let me know
I thank you.
Sean
I am having trouble with an Inventory DB I am building. I know the general theory of calculating inv on hand as opposed to storing it, but this is the issue:
I deal with a book buying company, and as such, there is a pool of over 500,000 records that contains book information. this is tblAT. I also have tblInv which contains ISBN, Quantity, and Condition of the book. I have a query that pulls records from both tables, and assigns a SKU which is a combination of 4 letters of Author, 4 Letters of Title, last 4 digits of ISBN, and a condition id number. I have built a form which enters this info, and a subform which displays the individual records in the above query. The purpose is to display the recent records that were just entered in the subform so that the user can easily spot any data entry errors.
I want to keep a summed quantity of each sku (each book will have 4 sku's which are calculated in the aforementioned query, as we use 4 different condition designators). I wish to use a form to select books for my warehouse guys to pull from the shelves and adjust my quantity on hand. The question is, what is the best method to accomplish this. I will have a checkbox and quantity, then update query to subtract QSold from QonHand.
I thought about a make-table query on the OnClose event proc, but I'm not sure thats the best idea, because the make-table could take too long to run, plus multiple users will be entering info at once.
If anyone has any ideas, please let me know
I thank you.
Sean
Last edited:
