Container with data from other table

[Coriolan_66]

Since Bento iis no longer updated, I started my db for my students over with FM Go. Please consider three tables :students:, :subjects:, :aplications:

During time, students have several aplications on various subjects, ok?

In each application, students updates their address, email and... photo

In students main layout I have successfully created a portal with sorted aplications over time. I also have a beautifil big portrait near the name and wish that portrait to display the photo of the most recent aplication available for that student.

So :students::portrait is a container with calculated value GetNthRecord (:aplications::aplications_photo;0)

I unchecked Auto-Enter/ do not replace existing value of field

I also tried to set field as Looked-up value with "copy next higher value".

No photo displais so far. Need help.

[comment]

So :students::portrait is a container with calculated value GetNthRecord (:aplications::aplications_photo;0)

 

First, the field should be a Calculation field with the result type set to Container.

 

Next, the value of 0 makes no sense as the recordNumber parameter in the GetNthRecord() function: there is no zeroth record - the count of  records starts at 1.

 

Assuming applications are entered chronologically and that the relationship is not sorted otherwise, you'd use the Last() function to get the most recent value.

 

 

---

P.S. Why do your table names begin with a colon; are you out to confuse yourself or others?