I am new to Web DB. I have made great progress in the last 72 hours in navigating this new monster but in terms of positive outcomes, I am just scratching the surface...
I want to track inventory for styles that come in different colors and sizes.
I created one table for companies, one for styles and one table for colors.
I created a transaction table with a company field, transaction types (Sale, Lend, Consignment, Return, Production) and date
I created a transacion detail table with ID from the transaction table, style, color, size and Qty.
I created forms with subforms to enter information onto the tables.
I created 2 Queries one for Inventory Additions and one for Inventory Deductions by filtering transaction types.
Any help on how to proceed to show the Qty on Hand by Style, Color and Size?
If you'd so kind in explaining where to go as I don't understand "Code"