Hello --

I'm trying to setup a layout where I have a portal showing all records of, say, "classes". In this portal I need to match the current record of the layout to the row's record.

all_classes is a cartesian product of class:

class::id x all_classes::id

I defined a field in class called "__is_current" as

If(id = all_classes::id; 1; 0)

Problem is now that the rows only match the first class record, not the currently shown.

Example:

Viewing class id 1, the portals reads:

all_classes::id | id | __is_current

1 | 1 | Yes

2 | 1 | No

3 | 1 | No

Viewing class id 2, the portal reads:

all_classes::id | id | __is_current

1 | 2 | Yes

2 | 2 | No

3 | 2 | No

while it *should* read:

all_classes::id | id | __is_current

1 | 2 | No

2 | 2 | Yes

3 | 2 | No

Am I doing something wrong or isn't this possible with Filemaker?

Thanks for any hint

-- erik

test.fp7.zip

What is the purpose of this calculation? It's not really possible because there is no 'flag' to mark the current record in a table (there could be multiple 'current' records in multiple windows, for example). It's more of a window/layout thing - and you CAN highlight the portal row showing the current parent record, using conditional formatting.

Thanks already,

in my real database I'll return a colored pattern from a global media field to highlight the portal row showing the current parent record, as you said.

Just having a blackout, but how to write the condition for the conditional formatting?

Sorry, I haven't noticed your version before. I'm afraid we have a misunderstanding: you can do this quite easily using version's 9 conditional formatting, but you cannot do this using calculation fields alone.

To use a calculation field as you want, you will need to use a variable that will be evaluated on screen refresh - see the attached.

testCF.fp7.zip

Hi comment,

The file doesn't not have a CF, and the formatting doesn't show in 8.5 of course.

Lee