Would it be possible to create a simple inventory system and only use tables, queries and forms without getting into complicated VBA codes?
My requirement is extremely simple:
1- I make a list of product to buy
2 - I go buy it at different stores
3- I enter what I bought referencing my shopping list
4- most of what I buy uses JIT inventory system (just in time) but sometime what I buy comes with many unit per boxes and would like to keep count of what I bought, used and what is left on the shelf.
My problem is I keep hitting the same wall:
error message: Can't add records; join key of "inventoryT " not in recordset
My requirement is extremely simple:
1- I make a list of product to buy
2 - I go buy it at different stores
3- I enter what I bought referencing my shopping list
4- most of what I buy uses JIT inventory system (just in time) but sometime what I buy comes with many unit per boxes and would like to keep count of what I bought, used and what is left on the shelf.
My problem is I keep hitting the same wall:
error message: Can't add records; join key of "inventoryT " not in recordset
Comment