getnthrecord and data tunneling

[ddreese]

I'm guessing these two don't work together. The attachment is a screenshot of my relationship graph and field definition.

I have no issues with getting the correct data from the L_placement_episode_pt_current TO, but the data I get from the L_placement_episode_pt_current_pv TO is random and not what I was looking for. A workaround is that I can have a CALC field in the the L_placement_episode_pt_current TO looking to the other TO, but that seems too FM6 for me.

I'm using getnthrecord because the the L_placement_episode_pt_current TO is sorted and I want the second record in the found set.

Any suggestions?

[comment]

I don't think Filemaker selects the result of a calculation at random. If you place a portal to the source table next to your calc field, you should see that the calculation returns data from the second row of the portal. As a rule, relationships ignore found sets.

[ddreese]

Well no, it was not at random, but it didn't seem to follow a set pattern, either. I did put the portal next to the calculation and it seemed to work fine, until I deleted the first record in the portal, you'd think the calculation would have changed... But it didn't, it stayed the same even though the data was now the first record of the portal. Weird weird stuff.

A better workaround that I've found (since I'm more or less just displaying the information and not doing anything with it per se) is using a portal and just starting the portal at the second record (not sure if this is a new feature or not, but it's handy). I think that may be the best way to go about what I was trying to do, though I'm not sure if I'm going to be screwing myself for something else just yet. I guess we'll see.

[comment]

I deleted the first record in the portal, you'd think the calculation would have changed... But it didn't

I think it would have, if it was unstored.

[bruceR]

But you still have to do something to refresh the screen. I'd suggest using a script to delete the portal row. First script step: Freeze Window. That way after the row record is deleted the screen will refresh. You're just dealing with the ordinary effects of related record calculations and what makes them refresh.

[David Jondreau]

Also make sure the portal is not set to sort...thereby showing a different 'first' record than the relationship sees.

[ddreese]

The portal is not set to sort, the entire relationship is. It's just something I do as a habbit to minimize problems later.

Also, I had a manual refresh button on the screen and it didn't update the information. Also I popped into layout mode and back into browse mode and it still didn't update.

The more I think about it, the more I realize I really don't need to use getnthrecord just so I can display the data on the screen. Now if I was doing any sort of calculations based off that information or whatever, maybe that would be more helpful. I think I'm just going to give up on the idea for now, and scurry back to my FM8 n00b cave

Thanks for all the help and suggestions :