4 Replies Latest reply on Jan 15, 2014 10:50 AM by Tracy Rodgers

    Do linking fields have to contain unique values?

    Stephanie Rosenberg

      For example I have two excel spreadsheets of a list of employees. Each employee is paid out of a specific GL account #. If you're a manager in New York you get made out of account 1 if you're a manager in Pittsburgh you get paid out of account 2. One spreadsheet is wages, the other is hours, I want to link them and populate records by a variable and that variable is GL account #. So GL account # will contain duplicate accounts because we have managers all over the US in different cities.