>>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.
It will be a better idea if you set a relation to a cursor/view
which is activated throughout your application as your checkbox
get selected give a value true to your cursor or view .Outhere
you'll be using a grid from your main table and relation setted
cursor/view.
I have practically tried out this and its really working perfect
with multiple operations like groupings of the selected records
which could be given a title to retrive at latter use.
For more detail e-mail me on
aashish@winsmart.com.