X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Data-driven Cascading Data Validation Lists    
post Mar 14 2012, 08:58 AM

Utter Access VIP
Posts: 6,289
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.
Attached File(s)
Attached File  Cascade_Dropdown.zip ( 383.35K )Number of downloads: 37
Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    7th August 2020 - 07:00 PM