3 Replies Latest reply: Jul 23, 2014 11:21 AM by BAIKANG CHEN RSS

    Dynamically Applying Consultant-Team Map

    BAIKANG CHEN

      Hi:

       

      We have a Lookup table for assigning teams to different consultants.

       

      But the consultants could change teams. If we simply change the team name in the look up table, historical data will move to the new team with the consultant and we don't want that. We want the historical data is still link to the same consultant with his old team.

       

      How can I achieve this with minimum maintenance?

       

      Thank you very much.

       

      PC