Oracle Forms

Dear Fellows,

I have developed a from which has two lists One for Major (say) and Other for Minor (say), thesr minors are based on the value of Major.

Now I have developed this system on Windows XP Professional, Developer/2000 6i and Oracle 8i (release 8.1.7).

Major list is populated from database and it shows all major values now using 'when_list_change' trigger the minor list is populated from the database based on the value of major list. Interestingly enough it is working fine without any problem.

Now I have deployed the software to Windows 2000 Professional/Server (tried on both), Developer/2000 6i and Oracle 8.0.5, but strangly the lists are not working now. First list (major) is still working but the other dependent lists are not working.

Another strange thing is that it populate the second list for one particular value (only at times).

The logic is that I have used a program unit to which i am passing 'list element' and 'query' and call it for each list in the when-list-change trigge.

Now its a very strange behaviour, I don't know what to do?

Your cooperation will be highly appreciated.

regards.