Skip to main content

Hello,

Beginner query builder here. I’m attempting to build a report that shows part number, description, available quantity, current year in and out, and last year in and out. At first, I couldn’t seem to find the view for the current year and last year in and out, but I was able to locate it after unchecking the “Only Granted Views” and “Only Base Views” boxes in the options drop down. There are multiple views titled “Inv Part Config Project” that has all the columns/keys I need, but when I attempt to join, there are no matching keys to connect. So I guess my 2 questions are:

  1. What do the two options boxes (Only Granted Views and Only Base Views) mean and how does that affect the views and how the join?
  2. What steps can I take to join two views when there seems to be no matching keys?

Thanks,

Be the first to reply!

Reply