Filter Portal & Value Lists

[cmury]

All,

I think I'm missing something in my current setup so any help would be great.

I have 2 DBs - Interface and Data. In the interface file I commonly use a global Keyword field [KF1] to filter portals. This filter is based on a relationship to a calculated Keyword field [KF2] in the Data file.

KF2 uses various text functions to establish keywords for a each record. It retrieves words or parts of words from various fields. But it also includes retrieving text from a value list. This value list only exists in the Data file and relates to another table within that file. All of this seems to work fine with the expected dynamic results in KF2.

My problem comes with the filtering of the portals in the Interface file. Basically when information that effects the value list in Data is modified from the Interface file, the value list [and consequesntly KF2] is not updated. Furthermore sometimes the filter returns no records at all when the realtionship with KF2 shows that it should.

I'm thinking that this could be the result of a couple of things:

1 - The value list is not truly dynamic and tending to 'choke'

2 - It has something to do with the storage of KF2 [currently set at never]

3 - A quirk with FM [i just had to put this one in!!]

Hope this explains the problem clearly. Any help/suggestions would be greatly appreciated.

Thanks

C

[cmury]

All,

I think I'm missing something in my current setup so any help would be great.

I have 2 DBs - Interface and Data. In the interface file I commonly use a global Keyword field [KF1] to filter portals. This filter is based on a relationship to a calculated Keyword field [KF2] in the Data file.

KF2 uses various text functions to establish keywords for a each record. It retrieves words or parts of words from various fields. But it also includes retrieving text from a value list. This value list only exists in the Data file and relates to another table within that file. All of this seems to work fine with the expected dynamic results in KF2.

My problem comes with the filtering of the portals in the Interface file. Basically when information that effects the value list in Data is modified from the Interface file, the value list [and consequesntly KF2] is not updated. Furthermore sometimes the filter returns no records at all when the realtionship with KF2 shows that it should.

I'm thinking that this could be the result of a couple of things:

1 - The value list is not truly dynamic and tending to 'choke'

2 - It has something to do with the storage of KF2 [currently set at never]

3 - A quirk with FM [i just had to put this one in!!]

Hope this explains the problem clearly. Any help/suggestions would be greatly appreciated.

Thanks

C

[cmury]

All,

I think I'm missing something in my current setup so any help would be great.

I have 2 DBs - Interface and Data. In the interface file I commonly use a global Keyword field [KF1] to filter portals. This filter is based on a relationship to a calculated Keyword field [KF2] in the Data file.

KF2 uses various text functions to establish keywords for a each record. It retrieves words or parts of words from various fields. But it also includes retrieving text from a value list. This value list only exists in the Data file and relates to another table within that file. All of this seems to work fine with the expected dynamic results in KF2.

My problem comes with the filtering of the portals in the Interface file. Basically when information that effects the value list in Data is modified from the Interface file, the value list [and consequesntly KF2] is not updated. Furthermore sometimes the filter returns no records at all when the realtionship with KF2 shows that it should.

I'm thinking that this could be the result of a couple of things:

1 - The value list is not truly dynamic and tending to 'choke'

2 - It has something to do with the storage of KF2 [currently set at never]

3 - A quirk with FM [i just had to put this one in!!]

Hope this explains the problem clearly. Any help/suggestions would be greatly appreciated.

Thanks

C

[cmury]

See discussions in Separation Model forum.

http://www.fmforums.com/threads/showflat.php?Cat=0&Number=139870&an=0&page=1#139870