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?