I am trying to select a single record from a view from a separate table that matches the name of the person in the main table.  I can see all of the records in the view table when I do this statement

if Gender = "F" and Program = 1 then
select '4-T Chart - Women'
end

The table view has a field called Athlete which is the same name as the Profile Athlete in the main table.  I am trying to get the table view to only include the information of the records related to the Profile Athlete.  I have tried various versions of code to try and isolate the single athlete record(s) but the table view when I do this delivers no content.

if Gender = "F" and Program = 1 then
let x := 'Profile Athlete';
(select '4-T Chart - Women').Athlete = x;
x
end

Can you advise on a solution to this?  From here, I want to be able to show the records based on the most recent entry for the named athlete and then be able to expand to show possibly a selection of other athletes for comparison.