I was able to figure out how to make the relationships I needed to make in SQL Server by watching a video and messing around with it. However, I don’t seem to be able to reproduce the lookup relationship that Access creates. It uses a bunch of system relationships to pull this off, but I haven’t quite figured out how it works yet. What I created in SQL Server is similar, but I have to enter the key ID (and my table shows me the key ID instead of allowing me to select from a list of text and showing me the value for the key, instead of the key itself).
Still, it’s pretty good.
I can use select and join statements (that SQL management studio creates for me!) to add the data from this new table to my reports, which was my ultimate goal anyhow.
I was up super late last night figuring all this out and now I’m wasted, and a little annoyed because I haven’t been able to figure out how Access manages to do its magic with just a few extra relationships and an intermediary table, but … I have to remember to celebrate my accomplishments and now I can create relationships in SQL Server.
It’s crazy how you can see something and think: Yes, I want to create that! But then when it comes down to it, I feel like I could invest more time in this (I’m sure I could figure it out) or I could just type the numbers. Hahah, it would be easier to just keep importing Excel spreadsheets, which is what I wanted to avoid in the first place.