Ken-

(reordered to chronological)

>>>I'm trying to create a cursor with indexes that can be shared by multiple forms. I created a cursor and indexed in in Datasession 1. Then in a form with Private Data session tried to open it and got file in use. Is there any way to do this. I suppose could create a DBC and table and then use them.

>I'm trying to create a cursor of names,address,etc from the server (a local copy of the data) that can be used in a Grid. The users can then use the interactive grid search feature to locate the person to edit (data for that person will come from the server). I need multiple copies of this Grid working on multiple forms. When the user changes a record that information must be updated in the cursor and all of the Grids must be refreshed to show this updated data.

>The table on the server has about 10 indexes, but the cursor I'm creating has an index on every field. This takes too long to download data from server and index every field. Each time the Grid is opened it currently creates the cursor and creates an index for each field. If there's a lot of names this takes time.

If you do your SELECT INTO a TABLE instead then you can reopen it. I gather the reason you're trying to use a private datasession in the forms is some of the data you don't want to share. Just the customer grid.

Not that it's any of my business, but you have multiple forms with the same data on them all? You want each grid to be bound to the same record source essentially? Interesting.