When adding or updating a record I often find myself in a situation where I would like the selection (combo lookup) of field C to be filtered based on values I have set in fields A and B. Currently the Software Factory only allows you to create such a behavior when you include fields A and B to the lookup reference column list. This poses a bit of an issue when for example you would like to filtered based upon a date field.
There is a better way to create such behavior. If the Software Factory would allow you to determine the lookup combo values based upon a tabled value function. You could then include the values of fields A and B into the parameter set of the function.
Hi,
We are working on allowing function-typed tables to be created in the Software Factory. That will solve this idea
Hi@Mark Jongeling ,
Does this also include alignment of the combos, only the combo control now allows for example to show image and text.. Does this also gets to be included in this idea and a reference lookup? Especially in the latter it's something we're missing. In our case a status.. Where I want to see the icon + text.
Hi Freddy,
I do think that is a separate idea to this. This idea focusses on populating a combo box using the dataset retuned by a function-typed table.