Data-driven Cascading Data Validation Lists
Mar 14 2012, 08:58 AM
Utter Access VIP
Joined: 22-June 04
From: North Carolina
In his FAQ article, King Martin gives an excellent tutorial on creating cascaded validation lists where the values for the selections are known in advance. If this is your situation, use those techniques. They are easy to implement.
This article addresses the issue where you don't know what kind of an animal you will get back in your data. On some days, it might be Dog, Cat, Mouse. On other days it could be Horse, Elephant, Sknunk.
The sample presented in this article is a simpified version typical of reports I do often where I need to get infromation based on a Manufacturer, Model and an attribute of the model such as its color. In some instances I may need the information down to the color level, in other instances I may need it rolled up at the OEM level. So I need not only a list of valid values, but also the wildcard character.
In this article I cascade down two levels: OEM to Model then Model to Color. The logic can be extended to go down any number of levels.
Cascade_Dropdown.zip ( 383.35K )Number of downloads: 29
|Search Top Lo-Fi||25th March 2017 - 10:40 AM|