Refining Search With Value List

[nutthick]

I have a three tables: Equipment, Manufacturer and Model, with a relationship between them. What I would like to do is when someone adds an entry into Equipment, they are presented with two dropdown lists (manufacturer and model). When the user selects the manufacturer I would like the model list to update, so as only to show the related models to that manufacturer. Can that be done? If my table architecture is screwed up it can be changed.

Thanks

[QuinTech]

Soren Dyhr recently posted a good fp7 example of conditional value lists in this post.

HTH,

Jerry

[nutthick]

Thanks Jerry. I'll have a play later on, as it look at bit more involved than I had originally thought. The example does exactly what I want, so the answer is there.

FYI I couldn't find any results in my searches. I was searching for stuff like, 'value list refining', 'value list search', 'compound value list search'

[QuinTech]

Keep posting those search terms! The next time someone searches for 'value list refining' they'll get your post, which will lead them to my post, which will lead them to S