Believe it or not there have been and still are many using and/or referring to the Access template NorthWind. This template is an excellent beginning for depicting a manufacturer’s environment but there is no one upgrading, correcting or improving it. Many have asked questions in several forums but frequently there are no answers and the database template remains a homeless orphan.
A compelling question that has been repeated is why the core table “Invoices” never gets populated with currency amounts. Anyone trying this will see that an order can be created and populated with products and quantities from inventory that is priced, shipped to a customer on a specified date by a specified carrier, and then invoiced complete with ship date, amounts, prices, totals, etc. BUT… the invoice data never gets into the “Invoices” table.
Surely someone who has studied the VBA has uncovered the error by now but it has been kept a secret. Can anyone shed a light on this?
Thanks