Subscribe Bookmark RSS Feed

Data Filter Question

apeden

Community Trekker

Joined:

Jun 23, 2011

Is it possible to se the data filter up to only show possible selections based on the selections currently in place? So if I have two columns in a table named Product and Lot as below. If I select Product A in the data filter when I add a filter for Lot it shows me the lots from A and B not just the lots from A based on the product selection. I am trying to use the filter as part of a script to filter thousands of lots from a hundred or so product types.

Thanks
Allan

Product Lot
A A1
A A2
A A3
B B1
B B2
B B3
1 REPLY
mattf

Community Trekker

Joined:

Jun 23, 2011

Hi:

Perhaps Ms. Murphy and Lucas provide an something very close::
(A terrific resource for scripters!)

In their example, a list of auto models are populated based on a users car manufacturer choice.