I add some items into the database in other to load in a combobox then trying to add items to the second combobox in other to act as a sub to the first combobox.. i found out that i would need to select an item from the first combobox before i can add items to the second combobox.. for instance i have "state" as my first combobox and in each state, there are local governments and i would have to select a particular state in other to enter the corresponding Local governments. as a result of this, i will be having more than one entry on my state column and when i try to use it from the user's end, when i select state, it will contain more than one entry for each state... is there a way i can reduce redundancy in the combobox.. please i need help with this
You can only select the second set of items based on the information provided by the first. If you need to reduce the number of items for a single state then you will have to add some other criteria to your application. This is a logic issue rather than a coding one.
You haven't spelled out any kind of problem at all. We have no idea what you need help with. Frankly, from the small code snippet you posted, it doesn't look like you have any idea what you're doing or what you're target application is even supposed to be doing.
You're NEVER going to get a tutorial on using the API in a forum. There's just too much information to convey.
Also, nobody is going to write your code for you. YOU have to do the research on this and YOU have to teach yourself how to use the API. What good would someone writing your app for you do? You still really wouldn't know how it works or why.