I am developing a web application using JSP, struts, ADF BC with
JDeveloper 10.1.3. I have four entities:
Company(Cid, name,address,....)
Department(Did, name,...., fk_CompanyId)
Person(Pid, name,....,fk_DepartmentId)
TrackPersonSalary(fk_PersonId, salaryReceived, Date)
I want to input the TrackPersonSalary, but I like to narrow my search
by First, selecting the company by name(not id) ( thus all the related
departments will be listed in the next department list), then,
selecting the related department by name(not id)( thus all the
relevant employees will be listed in the employee list), then select
the employee by name(not id) and enter the salary he received and the
date received. Is it possible? It is better that all the navigation to
be handled in one JSP page.
Please tell me where to start and what to do. I have read the
cascading_last paper written by mills but I need the information for
my input form and can not DataForm.submit()when the combo changes. it
raises error. Moreover, how can use a concept such as LOV in my
application. The LOV here(JDeveloper, struts) seems to be like a combobox.
notice I am using struts, jsp and ADF BC.