I need to create a field that will show a field value from the second row of a related portal record

I have two tables.

Students and Grad info

I would like to display in a field "grad Year" created in the Students table that shows the value of the second portal value from the "Grad Info" table. I have been able to pull the first value but have been unable to pull the second. How would I create the calc for this.

Edited September 30, 200817 yr by Guest

Hi

if it is only a "show" problem then you don't need a calc; duplicate that portal and set it to show ONLY the second row.

It's not a show problem. I will be exporting the students table and need to have all portal records within the one extract row. I was not sure if there was another way to do it. creating a field that held the value was the only way I thought I could do it. Thanks for the reply...

Edited October 1, 200817 yr by Guest

I will be exporting the students table and need to have all portal records

Well, it rather depends on what/who is at the receiving side of the export, but it sounds like you'd be better off exporting from the child table, with some parent fields included.

Thanks to whom ever read this. I have figured the problem out. It only took 6 hours to bash it out. This was my answer: "GetNthRecord ( academic::YEAR1 ; 2 )" It was that easy. I didn't think that it would be that easy. I always try to do it the hard way.

The Grad table data which consisted of many records to the one record in the students table needed to be exported with the student data. We have a third party doing an online Alumni Community and required that data in that format. Thanks for the idea. I've noticed that you answer many of the requests in the forms. That's very kind of you to take the time as you do.....