Issue:
How do I create a Custom SQL Object in SmartFill?
Resolution:
SmartFill has two parts, one is the SmartFill Object (the what) and the other is the Repository (the where).
To create a Custom SQL object, you would first create a newObject and set the Type to Custom SQL. You would then use the spSmartFill.sql template that comes with the SmartFill download and edit the code for your lookup.
Lastly, you will need to add your lookup for the new object you just created to the Repository. You can use the Repository wizard to add the look up.
Note: Refer to the back section of the SmartFill manual for more details and examples. The manual is included in the SmartFill download.