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.

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.

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