AnsweredAssumed Answered

Getting a related record from an Nth record

Question asked by Musoguy on Feb 28, 2015
Latest reply on Feb 28, 2015 by Musoguy

Title

Getting a related record from an Nth record

Post

Hi folks, I seem to be a little stumped! I'll simplify the solution I am working on to try and make sense. I have three  related tables A, B and C. A is related to B in a one to many relationship and B is related to C in a many to one relationship. I am trying to retrieve a field's data from table C whilst in table A. However the record I am trying to find belongs to the second related record in table B. I can get hold of that record using the GetNthRecord function, but is there then a way to get the related record in table C from this record? I hope that made sense. Thank you so much in advance for any replies.

James

 

 

Outcomes