Renoir,

Here's a kludge to accomplish the first item.

use (dbc file)
lcProp = (dbc file).property
lcProp = AllTrim(SubStr(lcProp, AT(' from ', Lower(lcProp)) +5))
lcTable = Left(lcProp, AT(Space(1), lcProp))

It's clumsy, but it's something. ;)

>Is there a way to determine in code the name of the table a view is based on? ...and what if a view is based on a view which is based on a table? Can I still get the original base table name? Thanks!
>
>Regards, Renoir