Show REF_ROW options that meets conditions for user to choose

Situation: I have a data table called “Information” with a column to define the Projects’ key to refer, to what project that information topic in that row belongs to. These information will be related to each other using a column call “Related From” in the same table using column type “ref” to refer to the table itself.

Problem: One thing that happen is that when users create new information and trying to specify to relate the Topic, they will have a list of information topics from all projects to choose from. How can I filter that to so that the user can only see the information topics from the same Project.

0 2 148
  • UX
2 REPLIES 2
Top Labels in this Space