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  values and various permutations of the LOOKUP function, but I'm going in circles.