AnsweredAssumed Answered

Related Record from other table

Question asked by SyedHussain on Nov 4, 2010
Latest reply on Nov 4, 2010 by philmodjunk

Title

Related Record from other table

Post

Hi.

I have "Person" table and related table "surveys". Each record in person table can have multiple related record in surveys table. We use portal to view those multiple record of same person. I know Max and Min function can give me first and last record of survey table (assume I am using Max(Creationdate) or Min(CreationDate)) . Now question is I like to see Max -1 record. I mean second last record. I don't know how to access or find 2nd last record.

Person Table

================

Person1

Person2

.....

...

Surveys

==============

Person1

.........CreationDate1

.........CreationDate2

.........CreationDate3

Person2

.........CreationDate1

.........CreationDate2

.........CreationDate3

These creationDate records keeping adding/removing by users. How at given time I can access any related creationDate

Any help

Thanks

Outcomes