Search and list records in popup according to valu selected from dropdown list

[sawan]

Hello everyone,

OS:Windows 2000
SugarCRM Community Edition Version 5.0.0b
(previously it was Version 5.0.0ba)

Three custom modules are in question:HousingGroup,HousingSubGroup,HousingProvi der.

Each Housinggroup can have many housingsubgroups but not vice-versa.These two modules are related.eg.Housinggroup California can have HousingSubGroup's SanJose,LosAngeles etc.

Each housingprovider is related to many housingsubgroups and vice-versa.
eg.Great HousingProvider provides housing in LosAngeles,San jose etc. and HousingSubGroup SanJose can have HOusingProvider's Great housingprovider,Optimum housingprovider etc.


In Housing provider's detail view there is a subpanel of Housingsubgroup as both are both are related.

Now on clicking the select button on Housingsubgroup subpanel, a popup of list of all housingsubgroups is opened.


Now what i am trying for is:

1) Place a dropdown list of HousingGroups in this popup's search section and after selecting a housinggroup from this its only its corresponding housingsubgroups will be listed in the main listview below.

for this i have currently made a dynamic dropdown list which fetches all the housinggroups from DB and made a field in housingsubgroup which has this dropdown as values.
I have placed this field in search view in SearchDefs.php and it is shown with data when popup opens.
But this field deos not have any value in DB in HousingSubGroup's table because module was made much earlier with nearly 73 records entered , and this fetaure is to be added now.

But the problem is i dont know the flow for popup and where the query for fetching the records is declared.

What shall i do? Please guide me.
Its really urgent.
Your help will be very much appericiable.

[sawan]

i am trying to find out solution,please guide.
Its really urgent.
Your help will be very much appericiable