This has been answered at least three times today alone.
Please search and read the previous posts before you add a new thread.

Signature
Rick B
> How do I filter a lookup field (call it 'Brand') by first specifying a
> product in a previous lookup field (call it 'product')? - ie. If I select
> 'Microsoft' in lookup field one, the values of lookup field 2 changes
> accordingly.
potter - 28 Feb 2006 05:33 GMT
Rick B,
Here is an idea...ANSWER the question. It's not real helpful for you to
send us part-time user after something in the dark. Maybe you could consider
shedding a little light on the subject instead of the canned response "Please
search and read the previous posts before you add a new thread".
I've been on the site several times today and over the past month but have
yet to find a decent thread with a "Drill-down" form example. I think an
example would ANSWER a lot of users questions if you/someone would reference
it. I've read several threads but still can't quite find the desired
results. Granted, I have not checked every day but I have checked often and
have seen your response more than once. Not a good use of anyone’s time.
Much like other part-time users we source the site for help from “MVP’s” to
save time. However, your canned response is a dead end for those of us that
read other threads. Maybe you should consider letting someone else, that is
willing to be resourceful, ANSWER the thread!
BTW - I don't think you have ever replied to one of my questions but I've
read several of your canned replies to the same/similar question from other
users. Please don’t get upset with the same question and consider directing
users to a resourceful ANSWER. It would help those that have have been
searching and spent a lot of time on other threads...
WHERE IS A DECENT “DRILL-DOWN” EXAMPLE? HELP!
> This has been answered at least three times today alone.
>
[quoted text clipped - 4 lines]
> > 'Microsoft' in lookup field one, the values of lookup field 2 changes
> > accordingly.