It would be nice if table valued functions could be used as a lookup for a task. So the lookup changes dynamically with the input given. For example:
I want to limit the delivery weeks for a customer to choose from, depending on the delivery week of the active line the user is on. So if the user is on delivery week 202550, i want the ability to show the possible deliveryweeks 202548 till 202552 for example. A table values function could return this, based on the input param 202550. If there is another way of doing this, please let me know, but I can’t find it.
Thanks in advance for the reply :-)
Grtz, Gideon
