>One approach is to have a remote view defined as SELECT * and USE MYVIEW NODATA just so VFP has the structure to work with. Another is to use SQLTABLES() and SQLCOLUMNS() to get the structures of tables in the remote database, and then populate the oFieldCollection by looping through the cursors created with these commands.
>
>Doug

Thanks... I will look at these approaches. Also, we would love to see SDT support remote tables, so we would just have to look in the data dictionary for this info.

Does SDT hold persistent relation info? Or, it doesn't due to it being in the .DBC? For remote tables this is a item we would have to store.

Can you briefly explain the difference between .cAlias and .aTables and how they are used when creating this .cFilter string?

BOb