Connected List Box

D

DS

How do you select an item in one listbox and have related items show-up
in another listbox on the same form?
Thanks
DS
 
D

DS

DS said:
Thanks,
I'll give it a try.
DS
Click to expand...
I tried it. I have a Listbox on Form1..When I click on that. Form 2
opens with 2 Listboxes on it, Listbox1 is properly populated but
eveything I try won't populate that second Listbox. The first 2
Listboxes are based on Queries and seems to work fine. For the life of
me I can't get that second ListBox on that second form to populate.
If you have any more examples are suggestions I would appreciate it.
Thanks
DS
 
D

Dirk Goldgar

DS said:
I tried it. I have a Listbox on Form1..When I click on that. Form 2
opens with 2 Listboxes on it, Listbox1 is properly populated but
eveything I try won't populate that second Listbox. The first 2
Listboxes are based on Queries and seems to work fine. For the life
of me I can't get that second ListBox on that second form to populate.
If you have any more examples are suggestions I would appreciate it.
Click to expand...

You'd better give a bit more information about what you want to have
happen and how the list boxes are related, and show us what you tried.
 
D

DS

Dirk said:
You'd better give a bit more information about what you want to have
happen and how the list boxes are related, and show us what you tried.
Click to expand...
The first Form has an Item on it, lets say "Burger",its in the Products
Table...The second form opens and any modifier groups that I have
attached to "Burger" show up in the first listbox on the second form.
These groups are lets say "Toppings", "Temps", etc. Whenever you click
on one of these group names anything that is attached to "Toppings",
etc. will show up in the third listbox on the second form. I have two
other tables that I am working off of. Group Table and a Mod Table.
The Product Table is linked to the Mod Table and the Group table is
linked to the Mod Table.
Thanks, I appreciate your help.
DS
 
D

Dirk Goldgar

DS said:
The first Form has an Item on it, lets say "Burger",its in the
Products Table...The second form opens and any modifier groups that I
have attached to "Burger" show up in the first listbox on the second
form. These groups are lets say "Toppings", "Temps", etc. Whenever
you click on one of these group names anything that is attached to
"Toppings", etc. will show up in the third listbox on the second
form. I have two other tables that I am working off of. Group Table
and a Mod Table. The Product Table is linked to the Mod Table and the
Group table is linked to the Mod Table.
Click to expand...

Are you sure that last sentence isn't a misstatement? From the sound of
it, I thought the Groups table was linked to the Products table, and the
Mods table was linked to the Groups table. What are the relevant fields
in each of these tables -- the primary key fields and the foreign key
fields (i.e., the fields that link to the other tables)?
 
D

DS

Dirk said:
Are you sure that last sentence isn't a misstatement? From the sound of
it, I thought the Groups table was linked to the Products table, and the
Mods table was linked to the Groups table. What are the relevant fields
in each of these tables -- the primary key fields and the foreign key
fields (i.e., the fields that link to the other tables)?
Click to expand...
No...Both the Products and Groups Table is Connected to the Mods Table.
The Mods Table is Between Them. Do you think the Mods Should Be
conected to the Groups, then the Groups to the Products?
Thanks
DS

Is it possible to do a Drill-Down using 2 forms. The first having one
list box and the second form having 2?
 
D

Dirk Goldgar

DS said:
No...Both the Products and Groups Table is Connected to the Mods
Table. The Mods Table is Between Them. Do you think the Mods Should
Be conected to the Groups, then the Groups to the Products?
Thanks
DS

Is it possible to do a Drill-Down using 2 forms. The first having one
list box and the second form having 2?
Click to expand...

Most definitely it is, but I can't help you unless you answer my
questions. You have to remember that I do not know the structure of
your database, and I only know as much about what you are trying to
achieve as you have actually told me.

What are the relevant fields in each table -- the primary key fields and
the foreign key fields (i.e., the fields that link to the other tables)?

What are the logical relationships among the tables? If you've
established relationships in the database's Relationships window, what
are those relationships?

What is each list box supposed to show, at each stage of the user's
interaction?
 
Top