I need help!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two tables one with the stock and another one which is blank but contains the same fields with the stock one
When i input the barcode into my table which is blank i want the corresponding description found and copied into the tabl
How do i do this? When i enter a quantity in my blank table, i want that quantity of the same item identified by its barcod
removed from the stock table.
How can i perform this tasks

Actual names of tables are: Stock (Shop) and Temp which is the blank on
 
If I understand you correct you wish to copy data about a certain stock
(identified by its barcode) into temp.

You could use an append query with parameters. The parameter would be your
barcode and the query would simply add the description from the stock
table.. you could also set it to have two parameters: barcode and quantity,
so you could use barcode for filter and quantity as actual value.

--
Kailash Kalyani
MEA Developer Support Center
ITWorx on behalf Microsoft EMEA GTSC

George said:
I have two tables one with the stock and another one which is blank but
Click to expand...
contains the same fields with the stock one.
When i input the barcode into my table which is blank i want the
Click to expand...
corresponding description found and copied into the table
How do i do this? When i enter a quantity in my blank table, i want that
Click to expand...
quantity of the same item identified by its barcode
 
I have two tables one with the stock and another one which is blank but contains the same fields with the stock one.
When i input the barcode into my table which is blank i want the corresponding description found and copied into the table
How do i do this? When i enter a quantity in my blank table, i want that quantity of the same item identified by its barcode
removed from the stock table.
How can i perform this tasks?

Actual names of tables are: Stock (Shop) and Temp which is the blank one
Click to expand...

I'm wondering why you would want to do this *at all*. What's the point
of storing data redundantly? You might want to consider instead having
a simple two-field table containing the unique ID field (barcode
field) and a quantity, related one-to-many to your stock table. A
Query could sum all the barcode-entered transactions and subtract the
total from the original quantity in the stock table.
 
Back
Top