In this demonstration we've hard coded the values into field A (the Manufacturer field). It wouldn't take much work at all to get these from the lookup view, making both Field A and Field B fully dynamic.

The demo resulting from this article is pretty basic, but all the bits and pieces are there to allow you to rapidly integrate this technique into your applications and extend the basic functionality.

As for the Mazda, well it gave me three years good service before I managed to blow the engine up, but that's an entirely different story.

Happy driving.

Philippe Schlier worked on messaging projects for over 17 years, on Notes since V2. In 1995, he founded GSX, publisher of GSX Monitor, the most successful monitoring product for Domino, Exchange, BlackBerry and Sametime. While at GSX, he designed their flagship monitoring product, which is now used by 500+ clients worldwide. This allowed him to dive quite in-depth within the architecture of the various messaging and collaboration platforms, to share ideas and work with developers and designers from biggest software players, like (Iris/Lotus/IBM, RIM, Nokia, and Microsoft). Philippe is based in Switzerland and work now for Avonik, as independent contractor on software architecture, design and quality assurance. You can read his blog at http://avonik.com/blog.nsf and contact him via email at pschlier@avonik.com.