AnsweredAssumed Answered

Lookups, photos and repeating fields

Question asked by FMNewbie on Aug 11, 2011
Latest reply on Aug 11, 2011 by FMNewbie


Lookups, photos and repeating fields


Okay, I'm sure there's a better way to do this, but I have one table called EMPLOYEES with records including NAME and a container field for their PHOTO.  In another table, we can call it INCIDENTS, I would like to enter several employee names and have their photos pop up in a corresponding container field.  The two tables are related through the NAME field.

I have been trying to do this using two repeating fields of [10] values and various permutations of the LOOKUP function, but I'm going in circles. 

Any suggestions?