June 21, 200619 yr Well, I didn't get any response when I tried to explain my problem using just words, so maybe a hands-on realworld example that actually doesn't work is a better approach... See attached file. I'm trying to filter the contents of the left-hand portal on the shopping list layout using a relationship that uses a global key matching a calculated key. But I can't get it to work. I don't recall which of the 10,000 attempts I left intact in this file, but it doesn't work and I'm stumped. I need someone with working brains to show me what I'm too thick to figure out myself. ..Todd shopping_list.zip
June 21, 200619 yr 1. calc_filter-key should be stored and indexable; 2. global_filter-key should be unstored; 3. The global criteria fields must be in the same table (it will "work" if they aren't, but it won't refresh easily).
Create an account or sign in to comment