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!