Ok I guess what I'm seeing here is that I can have a field named quantity...and I'll just have to tell the woman who will be using this database to make sure that when she adds a book that's already in there she does the math herself and changes the amount of them?
Thorns
Nobody can make you...
Hi guys! I'm hoping one of you has an answer for me on this...
My inventory database is set up now except for one thing. If someone wants to enter a certain book and they have 20 copies of it, how can I put that in so that there isn't a new entry for every one of them? It needs to either add...
SkipVought,
Well let's put it this way... They just want the information to be somewhere and be computerized. They initially gave me the choice to do it in Excel or Access. I picked Access because of all of the great things you can do with it. So I went and bought Access for Dummies (which by...
oh boy...
Thank you both very much for your advice. How would I create my metafile? Can I have more than one?Yes these are probably not great questions but I'm no programmer. It does seem easier than starting over, although I'm willing to do that too if I have to as long as I get this thing...
I was worried you'd say that...the problem there is that my boss has specified several specific things she wants to see per category. (example: in books she wangts to have title and author and supplier...this can't also be in computers) Any ideas? Maybe put it all in one table like you said but...
Hello!
I am currently working on a database to be used for inventory purposes. I have 4 different categories of stuff (computer equipment, furniture, books, supplies)
So far I have made a table for each of these with an item number as the primary key as well as a table for department/department...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.