View and add

[wizcow]

Hi

I am trying to manage my inventory.

When doing a stocktake I want to;
1. view all of my inventory items on my Inventory form
2. then I want to add the actual inventory to each line

Each line has the stock item's info
eg. 'Part no.' 'Description' 'Price' 'Last Stocktake' and 'Actual Stock'

Say on the first item line we have showing;
'Part00196' 'Paperclips' '$.69' '10 boxes'

I want to be able to add in the 'Actual Stock' the number that are really one my shelf. Say, 8 boxes.

Problem: My Inventory form is driven from a select query that gets info from the Parts table and the Inventory table.
I want it to store the 'Actual Stock' in the Inventory talbe for me but I can't get the query to work right.

I hope this description isn't too long.
Thanks

Tom

 

[Rob.Mills]

Are you saying you want to be able to enter what the actual amount is and then have it take that number and set it as the new 'Last Stocktake'?

 

[wizcow]

I am struggling with one.

I think what I want to do is record the stocktake in the Inventory table.
I do want to keep a record of the last stocktake as well.

When adjustments are made I would like to know; when, who made them and what the old and new stocktake number is.

Tom

 

[Rob.Mills]

I think I'm understanding you a little better. You have two tables with a one-to-many relationship. Is your form setup as a single form or continuous. To be able to enter in the new stock while looking at the old stock you would have to set the form to continuous. Then you could put all the product info in the header.

Then you can add as many records to the inventory as you like.

Does that help you out?