Hi folks,
Hoping somebody can help me here with what is probably a fairly easy
question. I have decided to create a database for a load of stock which
I have to manage in my office as opposed to using a great big unwieldy
spreadsheet. I had hoped that I could use forms to add and remove stock
from the store etc etc.
My problem is this, I have created a table named products which holds
details of each of the individual products we hold and have also
created another table called locations which lists the various
locations within the store where things can be put. I did now need some
way of bringing the actual stock into the database. I did not make the
products table a list of stock as some items are held in quantities of
more than 1 and are defined by their serial number and repeating these
items in the products table seemed to go against the rules of database
design such that there should be little or no repetition in tables. So
should I create another table which lists the actual stock held or does
anybody have any other fancy ideas as to how i can get around this.
Thanks to anyone who takes the time to read this and gets to the end.
Paula