Hi
I have a table ("Vare") which contains products and stock.
When I make an order in my order module ("Lagersystem") i would like to update the field "Antalpålager" in the table "Vare".
The information comes from "Form_Lagersystem.Antal" which I want to use to subtract from "Vare.Antalpålager".
The problem is that I can't get it to find the specific record I want to adjust/update. I always update ALL records in the table ("Vare").
Here is some pictures since I can't upload the full database (I too big):
It says that I'm about to update 81 records (the full table)
It doesn't need to be a Query, but it needs to be run when I leave the field "Lagersystem.Antal".
Any ideas?
I have a table ("Vare") which contains products and stock.
When I make an order in my order module ("Lagersystem") i would like to update the field "Antalpålager" in the table "Vare".
The information comes from "Form_Lagersystem.Antal" which I want to use to subtract from "Vare.Antalpålager".
The problem is that I can't get it to find the specific record I want to adjust/update. I always update ALL records in the table ("Vare").
Here is some pictures since I can't upload the full database (I too big):
It says that I'm about to update 81 records (the full table)
It doesn't need to be a Query, but it needs to be run when I leave the field "Lagersystem.Antal".
Any ideas?