I have a linked Table Reference called "People" (which are all people's names) and another table called "Jobs". Each job has a number of different people involved. An example would be "Job1" will have "person1", "person2", "person3" and "person 4". I have managed to create a two formulas fields per person in the "Jobs" table, one to show the person's picture and the second forumla to show the person's name. Both are linked from the "People Table".

All works fine up to two people per job, as I have used in the code "First" and "Last". But the issue is that I cannot find a way to display Person2 & Person3 pictures and names in the formulas if four people were involved in a job. Is there a way input this in to the code to show these instead of first and last ie person1 and person 4?

first('Featured People'.People.'Person Image')
last('Featured People'.People.'Person Image')

Otherwise I would have to delete the formula fields, create an Image and Text fields per person and manually insert the same person's picture from the "Persons Table" into the Image field and Person's Name into the Text field, making the database larger in size when the picture is already there in the People table.

Many Thanks