Current Photo

[Poida]

Hope someone can help me.

I have got a number of fields with students pictures in them spanning kindergarten to grade 6. I am hoping to be able to display a current photo of the child regardless of what grade they are in. Teachers can navigate through a child's records from K to Yr 6. I want to be able to show only their current photo based on their current scholastic year.

Hope that makes sense

[MorFologist]

If you store multiple photos of each child in a separate table with child photo, ID, and year, how about...

A single portal row (by person ID), sorted by latest year (and just show top record/current photo)?