get related field calculation...?

[Dono K]

I have a field "x" that draws from a value list of the entire database's records. I want to create a field "y" next to that that shows the container contents of a photo field in x's record. Meaning, pick a spouse in field "x" and see their picture in field "y".

Calculation? How do I do that?

Thanks - Don

[mr_vodka]

if you create a new relationship from this selection field to the x field in the picture table, then all you have to do is put the related Y field on the parent layout.