Partial relationships hack?

[cellmaker]

Is there any way to set up relationships that are inexact or "partial"? I'm sure I've gone through this with myself before, but I can't remember if I found a solution or not.

To be more specific, I would like to create a relationship between two text fields (globalfield1<-->textfield2) that will act as a filtering relationship. If I put "c" in globalfield1, I would like all values in textfield2 to relate if they start with "c". This is, in effect, much like the way a type-forward drop-down list works. If I put in "ch" only values starting with "ch" are now related, etc.

If I were in find mode, this would be the same as looking for "c*", "ch*" etc.

An exceptionally laborious method (on the cpu, probably) would be to have a multi-key relationship using a calculation field with values such as

left(field2,1)

[The Shadow]

You could do something like this, using <= and >= to define the range, and have a prefixEnd calculation that's something like: prefix & "z" to give the end-point.

[cellmaker]

Hmm. I think you solved it. Thanks!