Database view unique records

[servicetrout]

I would like to create a database view with unique divisions from a table such as this:

[

dept1       div1     var_a

dept1       div1     var_b

dept1       div2     var_c

dept2       div1     var_d

dept2       div2     var_e

dept2       div2     var_f

dept2       div3     var_g

]

I want the view to look like this:

[

dept1     div1

dept1     div2

dept2     div1

dept2     div2

dept2     div3

]

After looking at the database view documentation, here

Specify a field to return

I couldn't figure out how to find the,   "View Field form" to restrict the variables returned ?

And, I couldn't see any way use a Where clause to make the set unique?

Any guidance would be appreciated.

-G

[shaik_irfan]

Glen,

I have similar issue are you able solve this?