Setting up a view for ODBC access

You may use a view to display records from a data source that you access using ODBC. On the Advanced tab of the Views properties box, you can enable the option "For ODBC Access: Generate unique keys in index." This option, in conjunction with a database command such as the NotesSQL DISTINCT clause, suppresses the display of duplicate records so that only unique records display in the view.

For example, suppose you request the following records from a relational database:

Record 1	Red	Green	Blue
Record 2	Yellow	White	Black
Record 3	Red	Green	Blue

If the property to generate unique keys in index is enabled, the following records will display in the view:

Column 1	Column 2	Column 3
Red	Green	Blue
Yellow	White	Black

Record 3 does not display because it does not contain unique data.

For more information on using this option with the NotesSQL DISTINCT clause, see the product documentation for NotesSQL on http://www.lotus.com/ldd/doc