Direct Database Lookup

I am looking for a way to convert a series of joins to a direct lookup. That will give me more freedom with the scripting and eliminate a lot of extra code. I attached an Image that explains what I am trying to accomplish.