Django Admin

Hi Team,

I have created 4 models ( class Company, class Department, class Section, class Employee )

Company Model has : CMP1, CMP2, CMP3, CMP4, CMP5(Year is the foreign key in this model)

Department Model has : DEP1, DEP2,DEP3,DEP4,DEP5 (Company is the foreign key in this model)

Section Model has : SEC1, SEC2,SEC3,SEC4,SEC5 (Department is the foreign key in this model)

Employee Model has : EMP1,EMP2,EMP3,EMP4,EMP5 (Section is the foreign key in this model)

Now I have created 2 more models (class Details, Class Map)

Details Model Fields:

salary

Map Model Fields : 

Company ( foreign key Company Model)

Department (foreign key Department Model )

Section (foreign key section Model)

Employee (foreign key employee Model)

Details Model will Map salary for the employees

I need to show these two models in admin page ( class Map as the inline model for class Details)

=================================================================================

ADMIN PAGE looks as below :

Details 

select salary range

 (drop down)

MAP [ inline Model ] : Need to Map employees who come under the salary range

1.  select Company      select Department        select Section       select Employee
   

           (drop down)              (drop down)                   (drop down)           (drop down)

     2. select Company      select Department        select Section       select Employee

           (drop down)              (drop down)                   (drop down)           (drop down)

     3. select Company      select Department        select Section       select Employee

           (drop down)              (drop down)                   (drop down)           (drop down)

======================================================================================

=> On selecting a company, we should display only departments in that company.

=> On selecting Department, we should display only sections in that Department.

=> On selecting Section, we should display only employees in that Section.

 

I am messed with this implementation, Please help me out in this. If possible please brief me the steps to follow on this implementation

Thanks in Advance

Regards,

Teja Y

LAMP

This e-mail message and any attachments are for the sole use of the intended recipient(s) and may contain proprietary, confidential, trade secret or privileged information. Any unauthorized review, use, disclosure or distribution is prohibited and may be a violation of law. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.