Problem with form VB question

[martin007]

Hello,

I have a database with different information about the hardware and software on our network. I already made a form that is sorting the software by computer name.

What i want to do next is a bit more complicated maybe someone that know visual basic pretty much could help me or if theres another way...

I have a few different table that i want to get information into a list box (if its possible to combine those information together would be very good).

I have a table called Processors i would like to display the field Mhz from this table into the listbox also i would like the list box to contain information from the table server_name i want the field os, ram and sp (those 3). From another table netcards i need the field title and ips to show up from that table. Also i want information from the table VideoAdapters from the field DeviceDescription.

Anyone have any idea of how i could do this ? all the data is already into the database my problem is just to create the form and make it do those operation.

What i want is a combo box which will get the server_name information (which is the computer name) and i want it to sort all the information from the table and the field into a list box. If its not possible then i will make different forms but i would rather have all the information on the same form.

Thanks,

Martin

 

[BanditWk]

You may have to create an underlying query and use the SQL code from the Query for the Row Source of the Combo Box. What you're asking CAN be done. However, at this point, it looks as if there is no link between the two tables and THAT could be a problem when you're trying to get all the information into one list box. If I'm understanding correctly, you have a list of Processors that you want combined with OS, RAM and SP, am I understanding this correctly? Therefore, the following list could be produced:
Mhz OS RAM SP
900 2000 512Mb SP2
900 XP 512Mb SP1
900 2000 1Ghz SP2
900 XP 1Ghz SP1
950 2000 512Mb SP2
950 XP 512Mb SP1
950 2000 1Ghz SP2
950 XP 1Ghz SP1
1.2 2000 512Mb SP2
1.2 XP 512Mb SP1
1.2 2000 1Ghz SP2
1.2 XP 1Ghz SP1
etc...

Now, what is the purpose of this List/Combobox? Is it to list what's currently in the tables? or...?
Roy McCafferty
aka BanditWk

Las Vegas, NV
roy@cccamerica.org
RLMBandit@aol.com (private)

"No need to send gifts, just send a smile."

 

[martin007]

What i want is to be able to select the computer name (Server_name)and get those information on a Form i want all those information to be selected when i choose the server_name.

The server_name field is included in each of those table

1- Processor is a table that include the field MHZ that i want to display.
2 - Servers is a table that include the field OS, RAM and SP that i want to display.
3- Netcards is a table i want to display the field TITLE.
4 Videoadapters is a table i want to display the field DEVICEDESCRIPTION.


Thats how i would like to form to look like.

Server_name Processor RAM OS SP VideoAdapters Netcards

Computer01 500MHZ 256 WinNT SP2 ATI Rage 128 3c905b
Computer02 900MHZ 512 WinNT SP1 Savage 3c905c-tx

The problem is i dont have any idea how i should do this.