One To All in a multi Rel

[RodinBangkok]

I have a bunch of attributes that I want to be able to view selectively in a portal. The attributes

are set via a global select field which is then tied to self relationship. No problems here, quite

easy with FM7 now...no need to do multi Rel calcs. However each attribute also has a wild card or

"All" option. I've accomplished this by using the replace function to set another field to be all

if the global select is all or set it to the attribute for that record. This works fine, but its

ugly brute force and for this application is ok as the quantity of records is quite small. But

if I want to do this on a large structure the replace funtion would be quite slow, especially since

there are about 6 attributes that must be set. I tried a calc field, but the relationship would not work.

Does anyone have a better way to set a wild card in a relationship that will essentially select all

records for that part of Multi relationship if desired.

Thanks Rod

[Fenton]

We just discussed something like this. Look here:

http://www.fmforums.com/threads/showflat...true#Post121413