AnsweredAssumed Answered

Repeating field lookup

Question asked by filler on Apr 7, 2009
Latest reply on Apr 10, 2009 by filler


Repeating field lookup


Is there a way to paste in repeating field 2 (a text field) lookups from another table based on repeating field 1 (a text field)?



Table 1 is Employees

Table 2 is Meetings


In a Meetings layout, I have repeating field Employee.  I would like to populate repeating field Company by pulling from Table 1.  (A relationship is based on Employee name.)  The Lookup function only populates the first repetition in Company.  I know I can create a script to do this, but I want to define the field in a calculation to automatically do it.