Re: create a small stock control and sales database

Tech-Archive recommends: Fix windows errors by optimizing your registry

Barry Claxton wrote:

Vincent, I'm sorry if I appeared dismissive of your advice to use the ready made "Inventory Control" database, it wasn't my intention! I looked at it and, for example fields like "Serial Number" and "Lead time" (you didn't tell me what that is!) are required fields, I cant delete them (it says). I reasoned that there would be more work re-structuring it than to start my own "from the ground up".

Well, even if you can't delete them (without first deleting the links), you could probably ignore them, and add fields of your own design.

Should I end up doing that then some of the advice you offer is very helpful. I intend to take a fresh look at "inventory control" and the "North Wind" Db as well.

I've played with a cross tab query and that appears to be the answer for keeping a running total of stock, both in and out, So... back to the drawing board! If you watch during the next couple of weeks for a posting using the same (or similar) heading as this one I'll let you know how I go on. I honestly think guys like yourself are stars to take time out trawling these postings and offering help. When one's working alone at home, sometimes it's great to be able to talk through your problems, thanks a lot.

Looking at a good-quality database like Northwind is an excellent way to become familiar with what you can do witn Access. Good luck!

  -- Vincent Johns <vjohns@xxxxxxxxxxxxxxxxxx>
  Please feel free to quote anything I say here.

.