I have a form with some textboxes comboboxes. On editing there is a combobox for selecting which user to edit. On selecting a user, i have managed to fetch all the records from the db. But now here the problem occurs -> There is a combox (say deptno) which is fetching only one dept no ofcourse for the selected user.
First Problem: Now i want is that the deptno combobox should have all the deptno's but the selected one should be the as per the selected user.
Second Problem: I have done something weird so the deptno is fetching the record of the selected user and the deptno next to it. So if i edit the users deptno from e.g 100 to 200 then the record is updating for 100 as well as 200.
Please help me in this i have wasted so many days as i am so new to coding.
Thanks in advance.