Multiple Tableviews and SQLite Queries

[lng]

Hi,

I am a newbie at iPhone programming and got my hands dirty with a navigation-based application.

Basically, I got a SQLite table and query it to display tableview in the RootViewController, then when user selects a row, it should push a new tableview and display new query results depending on which row user selected. Then another selection and another query&tableview. At the end it will have 4 tableviews and a detailview.

I figured out first tableview when application loads, but when user clicks I should make a new query with the selection and push a new tableview. That's where I stuck.

Can you help me out?

Thanks in advance..