Been using dbman for some time now, but what I want it to do now might be beyond it and only doable in relational database environments. But why not try and see if someone could help me with this.

If the database is structured like:

client1 | books | books1 | etc
client1 | books | books2 | etc
client1 | books | books3 | etc
client1 | video | video1 | etc
client1 | video | video2 | etc
client2 | etc

I want a listing first that says

client1 - books; videos

And only after I click 'books' here I want to see

client1 - book1
client1 - book2
client1 - book3

Can this be done?

Thanks for your time.

Bert Bulder, Amsterdam, NL