Parsing a realated table

[jshobar]

I'm stumped on this one, thought I'd try the forums.

I have a data base related to another data base. For the relationship I have defined, I get three related records for each record in my main data base. If I create a portal I can see all three matches for each record. I want to parse each of these values into 3 separate fields in the main data base. Using a calculated value for my fields I can pull in the first value using:

GetRepetition ( relatedDB::Value ; 1 )

however, GetRepetition ( relatedDB::Value ; 2 ) doesn't work

Last(relatedDB::Value) will pull in the last value

I need to parse Value in my related DB to Value1, Value2, Value3 in my main DB. any ideas? I would greatly appreciate any help on this. Thanks in advance.

Edited September 13, 2006 by Guest

[Ocean West]

Welcome to the forums,

You need to use GetNthRecord ( fieldName ; recordNumber ) not GetRepetition.

GetNthRecord( relatedDB::Value ; 1 )

GetNthRecord( relatedDB::Value ; 2 )

GetNthRecord( relatedDB::Value ; 3 )

[jshobar]

Of course! Thanks so much for the help.