relating relations....indexing issue

[3rdparty]

I am trying to create a portal based on a relationship that looks at two fields in a file, one of which is generated from another existing self-relationship. However I can't, as apparently the field that already depends on the slef relationship cannot be indexed. Is there any way around this problem?

In the attached example, the relationship I want to create would look at "UniqueProjBud" and "Unique key". But UniqueProjBud is already a result of a self-relation (that returns 1 or 0 depending on the uniqueness of the record) and thus the new relationship then will not work.

Grateful for any tips

jw

testdb.fp5.zip

[CobaltSky]

Hello jw,

There are a few ways to approach this.

One of them, is to use a filtered value list as the basis for the left-key for the relationship.

I've modified a copy of your file to set up your 'Unique ProjBudgSelf' relationship in this way. See attached.

testdb.zip