Describes what the spSmartFill.sql file included with SmartFill is used for.
The spSmartFill.sql file is a template for a SQL Stored Procedure that can be used to add functionality to your lookups that could not otherwise be done through the SmartFill windows. For instance, if you want to search using a complex series of JOINs to several different tables, you could use this stored procedure to do it.
If you do use this stored procedure, you will also have to set the search type to Custom SQL on the Object Maintenance window in SmartFill.
For more information on using the spSmartFill.sql stored procedure, view the appendix in the User Guide. You may download the User Guide here.