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_Componen t
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:
1  1079 
Just to prevent useless reopening everytime
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: JW |
last post by:
I'm displaying product thumbnails with brief descriptions on web pages. Clicking
on the product does a javascript popup with larger image and detailed
description info passed to the javascript functions from the table data.
Products can change frequently, and I want to make the maintenance of this
info easier by non-techies (each product has an image name, image width
(currently not using getimagesize), a short description, and a long...
|
by: Dave Posh |
last post by:
I seem to be having a problem displaying time stored in mysql. The
format stored in the database is 13:15:05. The database data type is
time. I'm using asp vbscript and sql to retrieve the time store in
the database. However asp recognizes the data type as date and
displays the date instead of the time. If I change the data type in
mysql to varchar then asp will display the time correctly, but I
cannot do it this way. I want to be able...
|
by: serge calderara |
last post by:
dear all,
I am building an application which is collecting data from a database and
display them in a windows form.
My idea is to collect those data in a form that, they can be read by my
windows application as well as a web browser.
is there a way to handle this data collection way available for both ?
|
by: ti33m |
last post by:
Hi All,
I'd like to include a datasheet on my user interface but since I'm
starting to run tight on space, I'd like to have a vertically-oriented
datasheet (column 1 has labels, column 2 has values), i.e. a
transposed datasheet or datasheet in column format. A vertical
datasheet will look cleaner, eliminate the need to scroll across (for
miles) and lay out bit more efficiently since I have some long labels.
It seems like Access only...
|
by: N. Graves |
last post by:
First... thanks for taking time to read my quest.
I have Access database that I have created that once it has been
deployed I will not know who has it or who is using it.
This is my idea but I'm not limited to this.
I would like to create a solution that allow the user to click a
button or some action that would go to an asp web page and tell them
that they either have a old version and needs to updated or they are
using the latest...
| | |
by: my-wings |
last post by:
I think I've painted myself into a corner, and I'm hoping someone can help
me out.
I have a table of books (tblBooks), which includes a field (strPubName) for
Publisher Name and another field (strPubCity) for Publisher City. These two
fields have a many-to-one relationship with tables, (tlkpPubName and
tlkpPubCity) respectively. The lookup tables only have one field (strPubName
and strPubCity), which is their primary key.
I also have...
|
by: RC |
last post by:
Dear Dudes,
I post this in multiple groups for opening brain storm.
Sometime I need to query the data from database server then display them
into user's browser in HTML <table>. But if the <table> is very LARGE,
let's say 20 columns, hundreds rows. Usually you have header <th> tags
on 1st (top) row and 1st (most left) column. For a such LARGE <table>.
you really want:
|
by: googlegroups |
last post by:
Hi, I'm making a javascript program for rolling dice for a roleplaying
game that's played in a forum. The die roll gets generated, gets stored
as text in a hidden form field, and then gets written to the mySQL
database upon form submission.
What I want to do is prevent cheaters from being able to create their
own die roll, and the best way I've come up with to do this is to
encrypt what gets stored in the hidden form field. However,...
|
by: Bob Alston |
last post by:
Looking for design approach ideas for collecting data from multiple
remote, standalone databases. I have built one of these in Access.
Another I am told was built in Access. some others the language and
database is unknown.
These systems are all in small agencies which provide utility assistance
to people who are having trouble paying their utility bills.
A foundation wants to provide funds. However they want a consolidated...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
