F
Fav
My Inventory must decrease after every sale. I have tried this in the Table
property without success
property without success
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Arvin Meyer [MVP]
Fav said:My Inventory must decrease after every sale. I have tried this in the
Table
property without success
Having a table for purchases and a tables for sales allows a query to
subtract one from the other and alway have the right answer (except for
theft and spoilage).
K
KARL DEWEY
Are you using Transaction records? Purchase type transaction equal plus and
Sale transact equal a minus. Then have Inventory Adjustment, Reconciliation,
etc records.
Sale transact equal a minus. Then have Inventory Adjustment, Reconciliation,
etc records.
A
a a r o n . k e m p f
use SQL Server and use triggers. HONESTLY.
Access doesnt' support this type of functionality.
If you're working for a _BUSINESS_ and they ask you to use a
_DATABASE_ default to SQL Server, not MS Access.
It's 10 times more powerful; cheaper; simpler-- SQL Server 'just
works'.
Access doesn't fit my needs; and the practice of using MDB is no
longer the reccomended route.
-Aaron
Access doesnt' support this type of functionality.
If you're working for a _BUSINESS_ and they ask you to use a
_DATABASE_ default to SQL Server, not MS Access.
It's 10 times more powerful; cheaper; simpler-- SQL Server 'just
works'.
Access doesn't fit my needs; and the practice of using MDB is no
longer the reccomended route.
-Aaron