05-12-06, 19:11 #1Registered User
- Join Date
- May 2006
Unanswered: I need Help - >Generalization and Log in / Password
I would like to know if someone could help me in the following problem
I'm making a database for a hardware store, and i need to make an iventory regarding paints, tools, machines, and others.
I had in mind setting up:
one table with the common aspects of the items (id, prices, etc) ,
one table in which the type of the hardware is indicated (id, discription)
4 other tables, regarding the specific components of each product
ex: table for paints would have (id, capacity, colour, and so on)
I would like to know how can i do this and how do I implement this sort of thought in the relationship builder within ms access 2000
The other thing regards the security isue. I was asked to create a user name / password system to protect the managing area of the database .
Thanks for reading
05-13-06, 17:58 #2Registered User
- Join Date
- Apr 2006
- Huddersfield, UK
Grand idea with regards to the db:
The table set up sounds fine; i'd make sure that any "option" fields such as hardware type maybe, are in thier own seperate table as it is eaier to add additional options (types) in the future.
With the Items tables id personally;
Item Type (from another table):
Item purchase cost:
Then you'd need a types table
You may also need additional tables to handle Sales, and purchases.
Also, i have a multi user-multi menu login system, pm me if you need it and i'll zip it up and send it you.
Dansometimes simple is best.... and i'm just a simple fellow.