Getting a related record from an Nth record
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.