Troubleshoot Lookups in ListViews

Overview

Understand how a list works so that when you do not see a newly added document in a list, you can locate it.

Steps

1. In the TierTree, navigate to the form where you added your new document. For this example we will use the Program Admission Log.
2. Right-click Tier Design, navigate to the ListView you would like to reverse engineer, and select it. 
3. In the Object Inspector, click to the right of the lookup. Your focus will be on the TTierLookup. This is where you will begin to reverse engineer the code behind the lookup.

4. To determine whether the lookup is using SQL, review the SQL properties. SQL code will override the Fields, Filter, and Table properties.

5. If the Lookup is not using SQL, TIER uses the Fields, Filter and Table properties individually in the Object Inspector to create the SQL.

SELECT [Fields Properties] FROM [Table Properties] WHERE [Filters]

6. To easily produce the SQL, run the form with the Show Lookup Queries option enabled, as shown below.

7. Pull the SQL into MSSMS to troubleshoot. Start by commenting out a WHERE statement to see if you see more rows. This functionality will start to show you how the ListView works.