By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
449,277 Members | 1,255 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 449,277 IT Pros & Developers. It's quick & easy.

Need Some Suggestions (Collecting/Displaying Database Data)

P: n/a
Howdy,

I've got a little project going and I am trying to figure out a good
way to do this. But since I'm still learning I'm probably missing a
few obvious
steps. Also not sure if I have my logic right or not.

What I am trying to figure out is the process by which I pull the
information. I'm trying to populate a list box with items where
certain criteria are met.

The program is a tailoring program I wrote for star wars galaxies. I
am working on creating a custom outfit section where a user can
select various items of the outfit, for example shirt, pants, hat,
boots. Give it a label and then have it store that information to a
database.

Then in the program we have a combo Box with an option for Outfits.
When the Outfits item is selected I'm trying to populate a List Box
with the name of the outfit. However when I do this it adds all of
the item names, but I only want it to display the item name once, and
then list the sub components in a second listbox. Each Sub Component
has its own set of values (resources it takes to make) which is
stored in a different table in the database.
So for example Lets say I have a database with the following in it.

The Code is a code given to an item, test name is the name of the item
and the component is something that the item is made up of.

Outfit_Code, Outfit_Name, Outfit_Component
1,Biker Outfit, Jacket
1, Biker Outfit, Helmet
2, Commando Outfit, Shirt
2, Commando Outfit, Vest
I need to figure out when someone selects the outfit option from the
combo box, how to loop it through the database and then add the
outfit name once in a listbox instead of once for each row, but then
when selected display the components in it in a second listbox.
(Leaving this bit out for now till ready to tackle it) Then have it
open up another table and add up all of the subcomponent items
resources.

Anyone have any possible samples from other code or anything that
might be helpful. Perhaps some things to read that might get me
pointing on the right track. Or perhaps a different database
structure?

Thanks,
Owen :wink:

Nov 21 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Just to prevent useless reopening everytime
Nov 21 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.