look up multiple ranges

[niyrho]

I have a database set up that lists all the different devices we use. On a workorder we have to put down the part numbers. So on the work order I need to be able to select the part type first(column A) and then select a part number that is list under that part type.

For example, colomn A would have a series of linked cells. One would say detectors, another would say strobes, and so on. In colomn B, next to detectors would be part numbers of all the detectors we use. Next to strobe would be all the different strobes we use. And then in colomn C would be the price that goes with each part number.

I need to be able to select the device type, and then be able to select again from only the part numbers that go with that device type.

I don't HAVE to keep the same layout for the database. I just have no clue as to how to make this part work.

 

[swst]

Do a search here for
dependant validation lists

This should give you your answer


Steve