Returning distinct results of a field.

[Jtown]

Is there any way to return only the distinct results from a field. Say I have a field called category with a bunch of well....categories. Is there any way to return each category only once? I want to do this so I can link to a page that will have a <select> with the categories.

thanks

[Jtown]

nevermind...got it.

[Jtown]

hmm...ok another problem...the way I solved this was by making a value list of the category field. Now I have a sub category field and once I have clicked the category link, how do I display only distinct subcategories that match up with that category?

[scratchmalogicalwax]

Because you don't know what someone will choose untill they choose it you will have to refresh the page (or take the client to another web page) with the correct subcatagories when they have made their choice

[Jtown]

I think I found a fix. thanks for your help.