>>If I have view1 and table1 in the DE (one of the tables in view1 is table1), view1 being the default between the two, what do I need to say to use table1? Order by? Select? Index on? Set order to? Use? Between tables and views, this really confuses me.
>>
>>Thanks
>>JD
>
>If table1 is a source table to view1, do NOT put table1 in the DE. Only put the view1 in the DE. When the view is opened, the table will automatically be opened.
>
>Once the view [and table] have been opened, you can simply SELECT TABLE1 and SET ORDER TO SOMEORDER. YOu do not have to SELECT TABLE1 to set the order for that table. You can issue a SET ORDER TO SOMEORDER IN TABLE1

Mark,

The index for that table is a .cdx, and the primary key is a field called stocknum. I put in this code:

SELECT inventory
SET ORDER TO stocknum

It still gives the error "Table has no Index Order set". Any ideas?

Thanks
JD