inventory complex-key relationship

[toddj]

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

[comment]

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).

[toddj]

Cool. Thank you very much!