«

How do I programmtically get the relationships of a table??

I can get the list of columns:
dtFields = conn.GetOleDbSchemaTable(OleDbSchemaGuid., New Object() {Nothing,
Nothing, strTableName, Nothing"})

, but when I change it to Foreign_Keys, no data is returned.

dtFields = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Foreign_K eys, New
Object() {Nothing, Nothing, strTableName, Nothing})

ET,
What database are you using? If it's SQL, try accessing the system
tables for getting at this information.

http://www.microsoft.com/sql/techinf.../systables.asp

Jason

et wrote:
> How do I programmtically get the relationships of a table??
>
> I can get the list of columns:
> dtFields = conn.GetOleDbSchemaTable(OleDbSchemaGuid., New Object()
{Nothing,
> Nothing, strTableName, Nothing"})
>
> , but when I change it to Foreign_Keys, no data is returned.
>
> dtFields = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Foreign_K eys, New
> Object() {Nothing, Nothing, strTableName, Nothing})