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