Filtered Value List! no workee reel good

[Mandu]

Got same problem as another thread.

"Customer" record includes "Active" flag: 1 if active, 2 if inactive.

Defined new T.O. called "Customers_Active"; it is a self-join on Customers where g_Active = Active. (g_Active is 1 and global.)

Defined Value List called "Active Customers" using Name field from "Customers_Active" T.O.

Created Invoice layout, containing Name field that uses pop-up list using values from Active Customers.

But the pop-up shows ALL names, not just active ones.

Any suggestions?

Thanks Chap.

[fabriceN]

Didn't you forget to check the Show only related values checkbox and select the correct TO (Customers)?

Sorry for this stupid answer, but we never know.

[Mandu]

In my case, there ARE no stupid answers.

That was it. I'm not quite sure why that was needed, but I'll learn up on it. Thanks for your help!

Chap