Lookup combo values based on table value function

Related products: Software Factory

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. 


We are working on allowing function-typed tables to be created in the Software Factory. That will solve this idea :smile:

@Mark Jongeling since your comment is from 1.5 year ago and I am not sure when this was set to status Planned: can we expect this solution to be included in Release 2023.2?

PlannedOn the backlog
We are still planning on doing this, but it hasn’t been worked on for quite some time now. I'll set the status to On the backlog to reflect the status of the implementation.

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.