>Part 1:
>I'm creating a view using the following syntax:
>
>CREATE SQL VIEW myview AS SELECT *, .f. AS lSelect FROM Inventory
>
>Is this safe? (I'm wondering because it seems to be unnatural use of a view)
>
>Part 2:
>My purpose for doing this is that this view is bound to a grid and I need the lSelect field to indicate that certain records are selected. I use the Dynamic ForeColor and BackColor of the cells to highlight 'selected' rows so they stand out to the user and appear as selected. The user can Shift-Click to select or deselect records.
>
>I arrived at this solution because I am trying to make a grid have multi-select capability like a listbox. I want the user to be able to select multiple records by shift-clicking, clicking and dragging, or using shift + arrow keys, has anyone seen code to make a grid act like this?

Your approach seems too confusing. Imbed a checkbox control into one of the columns in the grid and set it's ControlSource to lSelect.