the same field in 2 tables but using one form same field

[clagar1610]

Hi, I am very new to Access. But I am learning pretty quickly!



I have created a number of tables and I am now moving onto forms, but struggling to find out how I can get data captured in one form to populate into 2 tables(if that is even possible).

Table 1- Inventory

Ok, so I have a INVENTORY TABLE where all the stock items, amounts and calculations are done. In this table I have a field called "Shrinkage" so putting in an amount in under "shrinkage" for a particular stock item would deduct it from the total stock amount.

Table 2 - Stock Shrinkage

I created another table, STOCK SHRINKAGE TABLE with the following fields - ID; Date; ProductName; Quantity; Reason; User ID.

So those are my 2 tables, I have created a SHRINKAGE FORM, using the same fields in the STOCK SHRINKAGE TABLE.

What I would like is when a user enters an amount under the "Quantity" field in the SHRINKAGE FORM, I want that exact amount to be stored in the STOCK SHRINKAGE TABLE under "Quantity" and also in the INVENTORY TABLE under "Shrinkage" for that particular stock item.

Sorry if my explanation is not clear, but would appreciate any help, cheers

Gareth

[orange]

This may be helpful from a context perspective. You might be able to fit your "inventory issues" into a larger inventory. scenario.
He also deals with StockOnHand at a given Date to deal with Shrinkage(things that don't show up on the in and out transactions).
http://allenbrowne.com/appinventory.html