I appreciate your time. My first attempt is apparently a failure. I am hoping to make the process as seamless as possible for my scheduler, and my first pass was quite confusing to use. I can't seem to get the info from my "installers" to show up on my "trips" by connecting to that "assignments" table. It wants me to add a new assignment. So I'm going to trips, then to assigments, and back again. It needs to be simpler than that.
I'm going to try to work this out. Your explanation makes a lot of sense. I watched the QB university video on it as well and it didn't seem that bad, but in real world use it didn't work the same as expected. I've probably missed something. Fortunately, these are new tables so there's not tons of data to be worried about.
