navigating pages using parameters

[akihon]

Hi all,

I'm really hoping that somebody can help, I'm also hoping that this isn't a re-post.

Basically I have two tables stored in a database one called company and another called department. I'm using JSF2.0 with the netbeans ide and have hit a brick wall. I need the user to be able to click a command button to view all companies which I have done quite happily, this returns a table view of all companies, I have added a link to the table to allow the user to view the departments linked to the company. This is where the problems creeps in.

I have to get the company parameter to feed that into a query to return all of the departments linked to the company. The primary key for the company table is companyId and the foreign key in the department table is department_companyId.

I have done the research untill my eyes are bleeding and still can't make sence of what I need to do. Can anybody advise me of the steps or pprovide links to where I can find the information as I'm new to JSF and I'm still having trouble understanding how it all works.

Many thanks for your time and efforts

[akihon]

OK never mind, I'll ask the question on a forum where people will take the time to answer

[DarrylBurke]

Abandoned thread, closing.

db

THREAD CLOSED