Filtering lookup fields

[Guest]

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.

 

[Rick B]

This has been answered at least three times today alone.

Please search and read the previous posts before you add a new thread.

 

[Guest]

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!