value list in UI layer

[skfbelgium]

Hello, I'm trying to follow the guidelines to create a separate file for the UI layer. But I don't know how I should implement the valuelists:

I have a table with projects and a table with project statuses. Some of the statuses are marked active.

Now I need a valuelist of the projects with statuses defined as active.

In the separate UI file, I reference to the projects database, define a relation between the projects and statuses.

I've created a table in the UI file (Active projects) with one global field 'active' and define a relationship with Project_status.

Now I would like to have a valuelist with the active projects in it. But when I restrict the valuelist to "active projects", the valuelist remains empty.

Thank you for your feedback!