Dynamic Portal Limiting in FMP6?

[n1k0]

Hi!

Could someone point me in the right direction with this? I've brought it as close as possible and attached an example (pick one, .zip or .sit)...

Two tables: Workers and Tasks. Workers (field initials) have multiple Tasks. Tasks have a status of A, B or C. I want a portal that displays all of a worker's records with a particular status.

In the attached example, change the value of the valuelist (the yellow field) in workers.fp5. The calculation in tasks.fp5 (the blue field) changes appropriately, but can't be used in the portal relationship because something won't index.

How do I create a relationship based on a calculation that contains a global?

This works beautifully in FMP7 but not 6...

Thanks for any advice!

N

tasks.fp5.zip

[-Queue-]

Multi-criteria relationships in 7 equal single-criterion relationships using compound fields in 6.

First, move gLimiter to the Workers table; it is not needed in the Tasks table, for this relationship. Then, create a calculated text field in Workers of

initials & " " & gLimiter

Do the same in Tasks with a calculation of

initials & " " & status

Now, change your relationship from Workers to Tasks to relate the first calculation (which will be unstored, due to the global) to the second (which will be indexed).

[n1k0]

Perfection. Immense gratitude!