AnsweredAssumed Answered

Value List that shows related records from a record ID in a global feidl?

Question asked by ezeitgeist on Jun 30, 2017
Latest reply on Jul 3, 2017 by ezeitgeist

I am working in a layout in the User Table.


The User selects a Project_ID from a portal of all User's Projects (User Table and Project Table linked by User_ID). This portal row selection puts the Project_ID into a global field, gProjID.


Projects are related to a table of Roles by Project_ID.


How do I create a Value List that only shows Roles for the selected Project_ID that is sent to the gProjID field?


I am using globals to log new records. I tried "using only related values from 'Projects'" table, but since the row is selected in a portal and sent to a global field that does not work. The Value List is set to use Role_ID but display 2nd field Role_name. I am using a pop-up menu for the field to display the name only to the User.


I essentially need, I believe, a show related records in Role Table for Project_ID = gProjID. How exactly do I do that?