Retrieving a portal row number from another file

[jfrick]

I have a Reservation.FP5 file with a self-relationship portal.

I'm using a calc field "Row" Status(CurrentRecordNumber)

to show the portal row number.

Sample portal:

Row RecordID

1 1047

2 1051

How can I pull the row number data into another file that has a many-to-one relationship to the file above?

[ December 17, 2001: Message edited by: jfrick ]

[ December 17, 2001: Message edited by: jfrick ]

[LiveOak]

Are you aware that the value of Status(CurrentRecordNumber) varies with found set and sort order? It will be different for each user. We definitely need more of the "Big Picture" about what you are trying to do.

-bd

[jfrick]

It's ok if the value of Status(CurrentRecordNumber) varies with found set and sort order? A row number is being used to display a color value from a repeating field "colorchoice" with ten repetitions. The colors are recycled every 10 records/reservations. On a Calendar view I show color-coded rectangles with room numbers - each reservation has it's own color. The records are sorted by date so you'll rarely see over 10 reservations on one calendar month.

[jfrick]

I don't know if this is the best way to do this -but it seems to be working. Instead of relying on calc fields I'm using a script.

Go to Layout [ReCalcRowNum]

Go to Record [First]

Go to Portal Row [First]

Loop

Set Field [ActiveRes::RecordNum, ActiveRes::CurrRecNum]

Go to Portal Row [Next, Select entire contents, Exit after last]

End Loop

[bbaliner]

Jeff,

I would do something like that with setting the global field in a related file, but I don't know enough about what you're doing. Anyway, it seems you found the answer.