[tonysandhu3]

Hello,

I have a table something like this:
Category .. Item Number .. Item Description
Item1 ...... Number 1 ....... Description1
Item1 ...... Number 2 ....... Description2
Item2 ...... Number 3 ....... Description1
Item3 ...... Number 1 ....... Description3

It needs to output some thing like this:
Item1, Number1, Number2 .. Description1, Description2
Item2, Number3... Description1
Item3, Number1... Description3

The output info will go into Dropdowns for all three fields in a form.

Any help is extremely useful, stuck on this issue for few weeks. Could not find any thing online.

I am programming in classic asp and Microsoft Access DB.