Source language: Translate to:

MDB Help

Questions about our Advanced Database plug-in

Moderator: Neosoft Support

MDB Help

Postby HackinHoodLogicsTm » Mon Jan 18, 2016 6:07 am

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
I am proud to be a Neobooker!!!
www.neosoftware.com
Special Thanks To
Mr. David Riley
User avatar
HackinHoodLogicsTm
 
Posts: 120
Joined: Wed Aug 28, 2013 7:03 am
Location: Ghana

Re: MDB Help

Postby stu » Mon Jan 18, 2016 7:36 am

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   |=|
      ----------------------
User avatar
stu
 
Posts: 318
Joined: Wed Aug 07, 2013 11:37 am

Re: MDB Help

Postby HackinHoodLogicsTm » Mon Jan 18, 2016 11:44 pm

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...
I am proud to be a Neobooker!!!
www.neosoftware.com
Special Thanks To
Mr. David Riley
User avatar
HackinHoodLogicsTm
 
Posts: 120
Joined: Wed Aug 28, 2013 7:03 am
Location: Ghana


Return to NeoBookDBPro

Who is online

Users browsing this forum: No registered users and 2 guests