Results 1 to 3 of 3
  1. #1
    MarcusW. is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Nov 2016
    Posts
    6

    Novice-New to forum-need Relationship help

    So, I realize my title may be somewhat mis-leading. By "relationship" help, I mean in the context of the forum. Not personally. Personally I'm ok, but I haven't spoken to my mom in months.

    However, my 2013 ACCESS database needs help/guidance!

    I've created this SAMPLE database to post for anyone to evaluate that is willing to help me. I've created it with pretty much the exact structure of my real working database I'm developing. So if I can get it to work in the sample, it will work for me otherwise.

    Here's what I'm trying to accomplish with this database:






    I'm trying to create an array of information that will tell me:


    At which KNOWLEDGELEVEL a MECHANIC has of each of the ACCESSORIES.


    At which KNOWLEDGELEVEL a MECHANIC has of each of the ENGINES.



    At which KNOWLEDGELEVEL a MECHANIC has of each of the SUSPENSIONS.



    A mechanic can have ALL of the levels (or less than all) for any (or all) of the components of the car (accessories, engines, and suspensions).







    I have created the tables, and some basic relationships. But I am a complete novice, and I'm stuck.


    I don't know how (or where) to create the relationships between the MECHANIC, the KNOWLEDGELEVEL, and the car components.

    I'll work on forms and stuff later.

    Thanks in advance for any guidance or assistance you offer.

    File attached. (I hope)
    Sample DB1.zip

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Mechanic table would be the master table.
    knowledge would be the child of tMechanic.
    tKnowledge table fields:
    KnowID (auto)
    MechID (long)
    Subject
    Make
    Level

    For mechanic Bob Smith , ID=101...
    1, 101, Suspension,Chevy,8
    2, 101, Engine, Mercedes, 10
    3, 101, Accessory,Chevy,3

    1 mechanic ,has many knowledges.
    this way you can find who knows about Chevys.

  3. #3
    MarcusW. is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Nov 2016
    Posts
    6
    I like the way you think! Thanks!
    I believe thats going to do the trick.

    Thanks so much for the help!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 03-19-2015, 05:26 PM
  2. Replies: 5
    Last Post: 07-26-2013, 11:12 AM
  3. Converting dBase forum to Access forum
    By amerifax in forum Forms
    Replies: 5
    Last Post: 07-03-2012, 01:12 AM
  4. Any forum for ASP.NET
    By coolpal9 in forum Access
    Replies: 1
    Last Post: 01-13-2012, 01:09 PM
  5. forum help!
    By karanvemuri in forum Forms
    Replies: 9
    Last Post: 09-06-2011, 11:10 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums