Ok, I have not set the column as a foreign key in the database.
Also, I have set the record set in the server behaviours pannel to fillter the UserID session variable. (Just like the profile page in security assist)
However on the results page I get the following message
No results for your search
However, if i remove the recordset the system returns with all results in the database, which is my problem