Hi,

If we assume for a second that you already have all the necessary security setup for the DB and you have a table that is similar to tigers jobs table then actually the query is really simple. Try the following:

SELECT Jobs_Table.Unique_id, Jobs_Table.User_id, Jobs_Table.Job_details, Jobs_Table.Other_details
FROM Jobs_Table
WHERE (((Jobs_Table.User_id)=[user]));
What this will do is every time the query is run it will first pop up a box asking for the user. It will then produce all the records in the jobs table that match the user_id.

Take a look at the file attached, run the report, i have only put in 4 records, and the user_ids are 1, 2 and 3.

Have a play