Renoir,

"Property" is a field in DBC files. Since a DBC file is just a DBF, you can issue a use. However, you need to specify the file extension to open a non-DBF extension file.

USE MyDBC.dbc
lcProp = MyDBC.property
....

Sorry about the strike lightening struck. Maybe you can get help from someone on the UT that deals with house calls repairs and maintenance? (bg)

Doug

>>use
>>lcProp = .property
>>lcProp = AllTrim(SubStr(lcProp, AT(' from ', Lower(lcProp)) +5))
>>lcTable = Left(lcProp, AT(Space(1), lcProp))
>
>Hey Doug,
>
>Not sure if I'm following... What is ".property" and how does the "use" fit in? What I'm trying to do is send a function the name of the base table of whatever the active view is at the time I call the function within the app. If my DBC is called Database1 and the base table is called Employee and the subsequent view is called v_Employee, I would want to send the parameter of "Employee" knowing that "v_Employee" is the view name. How would I plug all that into your code above at that time to return the base table name? Thanks!
>
>ps. I got your e-mail last week but lightening struck next to our house and we lost phones/adsl/e-mail since Friday... I'll get back to you as soon as everything is back up... J