By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,456 Members | 1,952 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,456 IT Pros & Developers. It's quick & easy.

creating a simple inventory

100+
P: 158
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
Jan 17 '10 #1

✓ answered by orangeCat

Please see this info on normalization:
Normalisation and Table structures

Share this Question
Share on Google+
2 Replies


P: 83
Please see this info on normalization:
Normalisation and Table structures
Jan 17 '10 #2

100+
P: 158
thanks you, I think I have resolved my question.
Cheers
Jan 17 '10 #3

Post your reply

Sign in to post your reply or Sign up for a free account.