Sending Info into A report

[jzwp11]

I provided the framework for the additional tables you would need for a typical inventory system. In a typical order inventory system, you have companies (customers) buying items from you and you buy items from other companies (suppliers) that you use to make items.

I guess we need to understand from you what your process is. Do you have a typical order inventory type application or are you dealing with some other type of process?

[JayX]

Sorry for not clarifying...I have a very basic inventory system. It doesn't even involve suppliers. The point of my inventory system is just to control what is going on within the company. For example if an employee of the company goes to the supply room and takes out 10 small gloves they will then click the '-' button I have in my form which then a message box will appear saying 'Please enter amount being taken" which it will then subtract that number from the total inventory. Goes for the same for the '+' button but obviously adds to the inventory.

[JayX]

Im attaching snapshots so you can get a visual of what I am talking about.

As you can see Joe Schmo added 5 bars of soap to the total inventory by clicking on the plus button. Once that information is done being entered the 'enter' button is clicked which it then brings you to the Inventory Control form showing detailed information about the inventory control.

My next step that I need to do is put the information on the Inventory control page into a report view so that every time someone adds or takes out from the total it keeps track automatically updating the report view.

[jzwp11]

For example if an employee of the company goes to the supply room and takes out 10 small gloves they will then click the '-' button I have in my form which then a message box will appear saying 'Please enter amount being taken" which it will then subtract that number from the total inventory. Goes for the same for the '+' button but obviously adds to the inventory.

The table structure I proposed should handle what you want to do. Instead of companies, you have employees. Also, you would not have a total inventory field. You would just record transactions in/out of inventory. The amount in inventory at any one point in time is a calculated value (add the additions to inventory and then subtract removals from inventory to get the current inventory total). You would use a query to do this. You can use a similar query on which to base the report you discussed.