I am trouble-shooting someone else's code and something caught my eye. The other programmer, who usually produces great code, specified a SQL VIEW with a column identified as 'KeyField', .T., but there is no TAG for the field in the base table.

I thought a KeyField had to be part of an index expression. Am I wrong?

The base table appears to get updated with no problem on test data and application running on a single machine. However, over the network of about 50 users, I have my doubts.

A second question, is KeyField only specified with .T. when it is part of the primary key expression, or should a field be specified as a KeyField if it is part of any index expression?

Please straighten me out on these two issues!

Your help is appreciated!

Thomas Allan