query help

[rick wilkins]

I have a db with 1 table and 5 fields with field 1 being the primary key.

I have field 2 as username and it wil have numerous records assigned to the username

I need to query the db and see a list of all usernames but do not want to see any username even though it may have many occurences but once in the list. (Can do that now)

Then through a master and detail page I need to see the username, be able to select it and then see all of the record associated with that username, now it only shows me 1 record, the one of the id passed.

Is there a way to do the with 1 db or do I need to split things up?