Oracle Forms

hi

i have another logical problem. this is the current situation:
i've got a table which is not normalized, but because i'm not the dba i mustn't normalize that, so i have to use this table...

here's an example:

login  | name    |     departement
=====================
mix     mister x       support
mix     mister x       helddesk
mix     mister x       secretary
miy     miss y         helpdesk
...

now i need two blocks. in block one i want to see just the login and the name (like a "group by login, name" query) in a form-layout, just one record at the same time and in block two i want to see every departement of the employee. i think if i had a master-detail relation it wouldn't be a problem but because of the table-design i don't know how to make something like a group-by in block one and how to make a artificial master-detail relationship or something like that.

Thanks for helping me...