Are the pick lists for 3 possible values really necessary? Simplify, then you're done.
You could do this...
SELECT bioID
, FirstName
, LastName
, Sex
, Status
FROM Bio INNER JOIN Sex ON Bio.SexID=Sex.SexID
INNER JOIN [Status]
ON Bio.StatusID=Status.StatusID
WHERE FirstName = @FirstName
AND LastName = @LastName
But picklists for 3 possible values are kind of overkill, I think. You can just as easily use a CHECK constraint, and a single character (M,D,S...) M/F