Search results

  1. T

    Verifying Table structures and relationships

    Effects are actually Presets. A Preset can be an Effect, an Instrument, or an Audio Clip. You set a bunch of settings on a VST and then save it as preset. The VST can be a sound producer (synthesizer), or a sound modifier (echo box). Each VST has many settings to make before you get what you...
  2. T

    Verifying Table structures and relationships

    tblSong would not be related to tblTrackEffects. tblTrackEffects was a joining table I was using because I was thinking the relationship between tblTracks and tblEffects was M:M. I'm pretty sure I am wrong and the relationship is just 1:M. The same for tblSongs and tblEffects. I had created a...
  3. T

    Verifying Table structures and relationships

    A song can have several Effects, but it is a 1-many relationship. Songs may share the same effect but that is only a coincidence. The effect may change for one song, but that change will not be reflected in other songs. A song has several tracks (like guitar, drums, synth, flute, etc.). Each...
  4. T

    Verifying Table structures and relationships

    Regarding the similar effects tables. An effect can be applied to the entire song (All Tracks) or individual tracks. It occurs to me though, that the Song-Effect and Track-Effect relationships should be one-many not many-many. The only real connection between a track and the instrument is the...
  5. T

    Verifying Table structures and relationships

    I am on iteration 5 of trying to create a database where I can store details for music I write using Cubase Software and other instrument/effect programs. I beginning to believe that it is my table structure and relationships that are causing my forms to not work as expected. Below is a brief...
  6. T

    I'm a long time user but very rusty

    I've worked with Access for over 20 years....off and on. Mostly Off. I've been coming up with projects to get back into good form. I'm hoping to find some help to reduce the learning curve. I am very grateful for anyone that offers their time and knowledge to help me build something useful.
Back
Top Bottom