Inventory probem

[lifeofasportsman]

I have an Inventory problem. I have set up a very large table with 8
diiferent variables and what I am trying to do is on four of them set
up a look up table. The diffacult part is when i open the first I need
it to open the second and only show items assosiated with the first
selection. For example:

make model color dr
ford taurus Blue 4dr
ford taurus Green 4dr
ford taurus Blue 2dr
ford taurus red 4dr
ford pinto red 2dr
ford mustang green 2dr
chevy camrero greenn 4dr
chevy tahoe blue 4dr
chevy citation red 2dr

look up
Make Model Color dr
Ford Taurus Blue 4dr
Chevy Pinto Red 2dr
Mustang Green


Where the first choice is Ford and returns The model choices of
Taurus, Pinto and Mustang. The Second choice would be Taurus the pop
up look up would return the color list of blue, green and red and so
on. My problem is should I use an if statement or is there something
else that can be used so I don't have to have a mass amount of if
statements
Please help
also how do I recieve the answer for this question?

 

[Vincent Johns]

I have an Inventory problem. I have set up a very large table with 8
diiferent variables and what I am trying to do is on four of them set
up a look up table. The diffacult part is when i open the first I need
it to open the second and only show items assosiated with the first
selection. For example:

make model color dr
ford taurus Blue 4dr
ford taurus Green 4dr
ford taurus Blue 2dr
ford taurus red 4dr
ford pinto red 2dr
ford mustang green 2dr
chevy camrero greenn 4dr
chevy tahoe blue 4dr
chevy citation red 2dr

look up
Make Model Color dr
Ford Taurus Blue 4dr
Chevy Pinto Red 2dr
Mustang Green


Where the first choice is Ford and returns The model choices of
Taurus, Pinto and Mustang. The Second choice would be Taurus the pop
up look up would return the color list of blue, green and red and so
on. My problem is should I use an if statement or is there something
else that can be used so I don't have to have a mass amount of if
statements
Please help
also how do I recieve the answer for this question?

Look for "subdatasheets" or "subforms", etc.

I would start out by defining a subdatasheet for the first Table,
[make], linking to it the second Table, [model]. I assume, of course,
that your "taurus" record in [model] contains a key linking it to the
"ford" record in [make].

You can test your subdatasheet by clicking on the little "+" sign at the
left of each row. The correct linked records should show up.

Link the other Tables the same way.

Then you can, in Datasheet View, select a make, displaying the models
for that make, select a model from that list to display a list of
colors, etc.

Having verified that that works, you may wish to set up a Form and
subforms to do the same thing, though I often don't bother if my client
doesn't care. The Datasheets may provide all the functionality you
need, and they make pretty efficient use of window space. But some
people here apparently dislike the idea of using Tables for data entry,
and if you agree with that, you'll want to set up Forms.

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.