Ozium Portal Filter Type CF with prefixes?

[gregincolumbus]

Anyone try this? I know the new relational model helps in this area, but I would love to have one portal accessing 4 fields and have a multi key created that has a prefix before exploding the field...ie

prefix1_a

prefix1_ap

prefix1_app

prefix2_M

prefix2_Mi

prefix2_Mik

prefix2_Mike

Left side would be a calc field with the prefix supplied from a popup and then the user entered criteria.....ideal solution would be clarivoyance type feature after the user has selected prefix and begins to type into the criteria field.

I have found some explodedstrings CFs but none that include prefixes.

Anyone? I am still a newbie to FMP8....sorry if this is a no-brainer

Thanks

Greg

[Ender]

With multi-criteria relationships, these types of concatonated keys are not really needed (unless there's some speed advantage I haven't heard about.) Multi-criteria relationships can be setup easily without additional calcs by adding each matching pair to the relationship definition.

But if you still wanted to use concatonated keys with an exploded key, you could simply substitute the prefix into the result of the exploded key:

substitute ( ¶ & ExplodedKey(Name); ¶; ¶ & Prefix )

where ExplodedKey() is an exploded key CF.