Please Help me, Making Relationships

[arif]

Hi,

Pupose of Database is to track Items Listing, Identifying What is the Category,Type and which Class it belongs. Creating reports and Displaying Listing.

I Created Three Tables Namely 1. UtblCategories 2. UtblTypes 3. UtblIsuClass 4. tblItems
1. Category is speacial only one category
2. Class is unique can belong to any one of Categories
3. Types are for usage type … all categories could be used for any Type, Type can belong to
One or more IsuClass.

Q 1. Should I make LinkTable with All three tables 1. UtblCategories 2.
UtblTypes 3. UtblIsuClass Primary Keys.
e.g. lnkCategoryID+lnkTypeID+lnkIsuClassID all together ?

Q 2. Or should I create LinkTable with lnkCategoryID+lnkTypeID as primary
key. and one unique key CategoryType
and than link Table UtblIsuClass ? :banghead:

How I make relationship between these tables please help me.
I do not know how to upload zip file of this Database. so could not
make attachment.
I shall be hingly obliged and Any help will appriciated. Thanks in
advance.


Arif

 

[jdraw]

Here is a link to a procedure for
-identifying business facts
-identifying subjects
-identifying attributes
-creating tables
-normalizing tables
-creating relationships

I think it will help you organize your info.
http://www.rogersaccesslibrary.com/Tutorials/Entity_Relationship.zip

Good luck with your project.

 

[arif]

Thank you very much jdraw for reply. And site referal. by the way it is no any pproject. Just am trying to learn relationship by way of real life senario.. in some of the Tempaltes etc.

1. Databases for mere Mortals
2. Access Vba by Katz
3. Access VBA by Susan
3. Access 2007 by Vincent
4. Microsoft MVP site...
5. Bob's Site...
6. Lebans.. site
7. Access VBA by Teresa Honing, Rob et al
8. Access Database by O'Reily
etc. etc will help ?
Oh yeh let me try these three tables making one after one find out. it may suite me but may not be right answer that I do not know. Probably somewhere,some how may get there...

Thank you very much great help...

 

[jdraw]

The items you have cited are all well respected.
The Hernandez book is very good and often quoted.
I have recently ordered a copy of the 2010 version of the Honing book.

I think you have enough references. You need to get all the facts related to your issue/opportunity, then go step by step thru the
procedure I suggested. That will lead you to normalized tables and useful relationships.

Try the procedure. First study the example and work it as a sample exercise. Once you understand that - do the same with your own data.

It takes some practice, and I recommend you start with a sample that has been "worked from basic facts to a final database" before jumping in to your own data.

Good luck.