5 Replies Latest reply on May 17, 2018 8:59 AM by Jim Dehner

    Join vs. Relationships to connect multiple sources

    Jessica Waydelis


      We are converting our employee incentive plan to a points system. Currently they are tracked on products open, by product. What we are trying to do is say that no matter the product opened they get a point.

      I want to join all of our separate files for product tracking and be able to add them to one workbook to track our new points system.

       

      I tried some joins, and played with the relationships a little. But I cant seem to get it to layout the way I want it.

       

      Here are some screen shots of how I want it to work along with the work book and some test data!

       

      If anyone has any insight on how to accomplish this I would appreciate it greatly!

      Operator.JPGBranch.JPG