Jump to content

Parsing a realated table


This topic is 6453 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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 by Guest
Link to comment
Share on other sites

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 )

Link to comment
Share on other sites

This topic is 6453 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.