Hello everyone I have another question in stock (1 Viewer)

yaron3500

New member
Local time
Today, 14:00
Joined
Feb 27, 2020
Messages
14
יש לי טופס משנה שמציג שאילתת בחירה לביצוע מכירות.
השאלה אם אוכל ליצור שאילתת עדכון שתפחית את הכמות בטבלת פריטים.
האם יש כל דרך שיכולה לעזור לי.
תודה לכולכם
 

arnelgp

once i caught a fish alive...
Local time
Today, 19:00
Joined
May 7, 2009
Messages
13,202
yes, you can use the Update query:

Update tbl_Item Set QtyOnHand = QtyOnHand - 1;

or if the subtrahend is in the textbox on form:

Update tbl_Item Set QtyOnHand = QtyOnHand - [Forms]![FormName]![textboxName]
 

yaron3500

New member
Local time
Today, 14:00
Joined
Feb 27, 2020
Messages
14
אוקיי איזה סוג שולחן אני מצרף לשאילתה
 

arnelgp

once i caught a fish alive...
Local time
Today, 19:00
Joined
May 7, 2009
Messages
13,202
the table you need to update.
please write in English, so I need not have it translated.
 

yaron3500

New member
Local time
Today, 14:00
Joined
Feb 27, 2020
Messages
14
I know why I asked which table.
I asked a question Form 1 Shows a sale through a query Choose within the query 2 Tables 1 Items 1 Extended sales
I want to update table only items
And once again what table is participating in the game
Many thanks
 

yaron3500

New member
Local time
Today, 14:00
Joined
Feb 27, 2020
Messages
14
‏‏‫תמונת מפת ‫סיביות ‫חדשה (6).jpg
עע
 

arnelgp

once i caught a fish alive...
Local time
Today, 19:00
Joined
May 7, 2009
Messages
13,202
as I can see there is no OnHandQuantity field on both tables.
it means that you generate the OnHandQuantity by Summing the Quantity from Received_details table on that particular Product_ID.
and subtract it to the sum of same Product_ID on the Sales_detail table.

you don't need to Update any table, you calculate the remaining balance on the fly.
 

Users who are viewing this thread

Top Bottom