Value list brain teaser

[herrix]

Here's a brain teaser that kept me awake all night yesterday:

In my example, I have a simple order system, where you select your items by selecting the item number from a pulldown menu. Most items are for any customer, but some can be made expecially for one customer and are NOT availlable for other customers than the one it was made for.

The pulldown menu now shows all the items in the items table.

But... I do NOT want to show the items that have a customer-restriction in that list. But I DO want to show the items that are resticted to the current customer.

AAAAAAAAAAAAAHHHHHHHHRGGGGGG

I cannot figure it out!

Any suggestions?

Reg. Herrix

example.zip

[Zero Tolerence]

Relate restricted items to the customer you want to see it ONLY. Set up your value list to show only related values.

[Paul de Halle]

If I get what you were trying to do, I think I've fixed it!

Let me know if this wasn't what you were after.

example_solution.fp7.zip

[SurferNate]

Nice solution Paul, two multikeys. Now that you've done that you would probably need a validation that prevents someone from switching the customer after entering restricted items into the list. Just a suggestion.

[herrix]

Ahhhhhh beddy bye time...

thanks Paul, brilliant indeed. Thanks for your help.

As for switching the customer... that would be a nice addon as well... But only if there's restricted items!

Hartger

Edited October 3, 2005 by Guest