5 Replies Latest reply on Jul 3, 2017 10:51 AM by ezeitgeist

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

    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?