Hi...

I have a problem with database.
Iam using SQLite db.

I have a table which contains two fields i.e id , title.
I can successfully insert the the values into table by using one textbox and button. when I fill the text box and press the button then the value goes to the table.

I can able to display the title values in a ListActivity

my problem is :

when i click on one item that should open another activity(which contains subllist values)
how can we display the sublist based on the titles List Activity.

each item in the list have the diff sub list .

please suggest me ...
how can i do this .. can i have to use content provider ???

please help me...