I have a form already has the “Client ID” in it
Next step is to select a Goal from the Goals that have been assigned to the client (for this example “a541ce98”) using a Valid If statement
I used Select( Goal assignments [Goal], [Client] = [_THISROW].[Client] )
The goal column is reference column to the Goals table
The results I get are just the applicable Keys listed in the “Goals” column of the “Goal Assignments“ table. How can I have it translate that in the goals listed I the “Goals” table?
|Goal Assignment ID||Client||Goal|