>No. You can programatically create views using your own syntax and force them into the DBC but I don't recommend it. If someone tries to edit the view using the view designer it may result in an error.

Thanks for the advice. It works now, but I have a method that runs in a combo on the form for search purposes that's giving me "Table has no index order set"
errors. Here's the code....


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
CLOSE DATABASES
OPEN DATABASE ('c:\diamondaccounti\inventory')

if !used('intrancust')
use intrancust
else
select ('intrancust')
endif


SET ORDER TO stocknum

SEEK Thisform.Combo4.value


IF FOUND( )
Thisform.CHARGEPERKARAT1.VALUE = chgperkt
Thisform.MEASUREMENTS1.VALUE = measure
Thisform.Combo3.VALUE = cut
Thisform.Combo2.VALUE = colors..............
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
the error points out the line "SET ORDER TO stocknum". I made that field an index in the view...was that not enough?