>>I have a following table:
>>
>>CREATE TABLE document ( doctype C(1), id N(7), .... )
>>INDEX ON doctype TAG doctype
>>
>>This table contains 200000 records and sometimes only some of them are of
>>doctype=='A' .
>>
>>BROWSE FOR doktype='A' works fast. I want to edit this table in a grid. I issue the command
>>
>>SELECT document
>>SET ORDER TO
>>SET FILTER TO doctype='A'
>>
>>in load event of a form.
>>
>>When this form runs, the grid will appear extremely slowly. It seems that
>>FoxPro will not use index in grid refresh: it scans the whole table. Also,
>>when user presses up/down arrow in first/last row, this scanning begins again.
>>Therefore, FoxPro cannot be used for data editing in a table.
>>Maybe this can be resolved using local views, but this requires using a database, but my table is for compatibility reasons free table?
>>Maybe the following trick helps: adding a dummy non-visible master grid to form and making dummy parent-child relationship. However, child grid order cannot be controlled if this is used?
>
>If the load time with a view is still slow because of the number of records, your idea of a dummy parent-child relationship should be extended to make it real. Use a lookup table that has JUST the doc types - A, B, etc. Use that DOCTYPES table as the master and your DOCUMENTS table as the child. Set the DOCTYPES to the correct record and be sure you have a tag on the document type in DOCUMENTS.

> Also, if you want to show the documents in a particular order, this tag could be on DOCTYPE + DOCDATE or any appropriate
> field name. I use this regularly to order child records in a grid alphabetically, by date, etc.

How orderring can be done? I tried to use RelationalExpr as

doctype+document.docdate

but this doesnt work!? It seems that
RelationalExpr cannot contain fields form child table.

Also, which is the best way to hide the dummy parent grid?
if I put .visible=.f. in parent grid, the child will display anything.
Maybe to move grid out from form using properties

.top=-10
.left=-10
.width=5
.height=5

Or are there other solutions?