Hi, Currently Lookup Wizards can only be based on a table and a where condition can be added. Is it possible to base the Lookup Wizard on a Custom View or SQL Statement? I am using MySQL 4.1 Regards, Gordon
Gordon, no, Lookup wizard work with tables only. With MySQL 5 you can use CREATE VIEW statement to create database views which can be used in Lookup wizard dialog.