Recent content by Stephenpoole4

Can you explain this? I want to be able to search and have all relevant results displayed. How can I create relationships with the harmonic keys in the second table? For instance, the song "Bounce Generation" is in the harmonic key of A. How can I structure the table/relationships so Bounce...

Re: My name is Stephen Yes, C is harmonic with F, G, and Am C#is harmonic with F#, G#, A#/Bbm D is harmonic with G, A, Bm D# is harmonic with G#, A#, Cm E is harmonic with A, B, C# F is harmonic with A#, C, Dm G is harmonic with C, D, Em G# is harmonic with D#, C#, Fm A is harmonic with D, E...

Re: My name is Stephen :) Yes, all musical keys have 3 other compatible musical keys. So, essentially, a song in the musical key of D corresponds to multiple songs in D and multiple songs in compatible keys (A, Bm, G). So it has a 1 to many relationship, I guess.

Re: My name is Stephen I didn't know that this website was associated with AccessForums.net when I made this post.

My name is Stephen I'm new to the forum. I think Access is gonna solve a lot of my problem. I withdrew from an Access class while at university. I was attempting to code database material in C++ until someone on a programming forum mentioned SQL, which reminded me of Access. All my needs are...

Essentially, I'm organizing songs in a few categories. I want to be able to search by song name and/or song key. For instance, if I search for the song "Stranger", I want to display the key for Stranger (which is the key of D) AND all other songs in my database in this key or a compatible one...