List Boxes

[BrianH]

Bare with me but I am fairly new to Access. I have a database with
approximately 40 tables. All of the tables are grouped in threes. I
am trying to to create a form in which I can have a list box/boxes,
that will allow me to chose which table and then which field in that
table. I need to run variances of these values that I pick and I would
create the query from there. Basically, I need a blank form like the
one when you start up the form wizard. You can pick what tables and
what fields you want in this wizard and I am trying to create this for
my database.

Thanks so much for your help in advance.

 

[Guest]

It sounds like your database structure is not normalized. Seems like these
multiple tables should be one with a field to signify the difference you now
use separate tables to segregate the data.
Give some more information about what you have in these tables. Some
examples of the data. How you plan to use the data.

 

[BrianH]

Wellll...I got the creation of the List Box that I wanted. The form
has a list box that has all o fht etables in my database which is
great. However, I need to be able to click that table in the list box
and in another list box have the field show up. I would Potentially
like to have that second list box pick and chose which fields I want
from whatever tables I have in the first list box. Does this make
sense? I think it is like the form wizard where you can move field that
you need over to another box.


I hope this wasn't too confusing. Thanks!!

 

[Guest]

Search on Cascading ComboBoxes

Wellll...I got the creation of the List Box that I wanted. The form
has a list box that has all o fht etables in my database which is
great. However, I need to be able to click that table in the list box
and in another list box have the field show up. I would Potentially
like to have that second list box pick and chose which fields I want
from whatever tables I have in the first list box. Does this make
sense? I think it is like the form wizard where you can move field that
you need over to another box.


I hope this wasn't too confusing. Thanks!!