Page 1 of 1

MDB Help

PostPosted: Mon Jan 18, 2016 6:07 am
by HackinHoodLogicsTm
Hi...

PPlease I need help on this issue

I have one database with two tables... Item Numbers nd Item Names

I wanted a way such that Item Number (1) in Item Numbers will correspond to different items in Item Names
Whiles Item Number 2 in Item Numbers will correspond to another different items in Item Names

Pls does anybody has a way out to do this..?
Thanks and will appreciate any comments

Re: MDB Help

PostPosted: Mon Jan 18, 2016 7:36 am
by stu
I have one database with two tables... Item Numbers nd Item Names

I wanted a way such that Item Number (1) in Item Numbers will correspond to different items in Item Names
Whiles Item Number 2 in Item Numbers will correspond to another different items in Item Names


This is insanely worded, btw.
If I understand the question you'll need to normalize your database to the third normal form
Post your database diagram to see whats going on, not enough details in the OP.

Here, this might help you understand my idea... Might not be the perfect example but its monday so I dont blame mytself.

Code: Select all
      -----------------
      | Categories    |
      -----------------
   -->|(PK)CategoryID |
   |  |  --Name       |
   |  -----------------
   |
   |  --------------------
   |  | SubCategories    |
   |  --------------------
   |  |(PK)SubCategoryID |<--- 
   -==|(FK)CategoryID    |   |
      |  --Name          |   |
      --------------------   |
                             |
      -------------          |
      |   Items   |          |
      -------------          |
   -->|(PK)ItemID |          |
   |  |  --Name   |          |
   |  -------------          |
   |                         |
   |  ---------------------- |
   |  |  ItemCategories    | |
   |  ---------------------- |
   |  |(PK)ItemCategoriesID| |
   -==|(FK)ItemID          | |
      |(FK)SubCategoryID   |=|
      ----------------------

Re: MDB Help

PostPosted: Mon Jan 18, 2016 11:44 pm
by HackinHoodLogicsTm
Thanks #stu for the reply...But I have aolved the issue now
I all I had to do was to give the items an identity and used that to fuilter it out. ..Thats all

And it works to.my satisfaction. ..Thanks to you all...