I believe you can do this with ADOX. If memory serves there is a "keys" collection off the table object that holds information about primary and foreign keys.
As for the WROX ASP conference, no I'm not going. I had a schedule conflict. I am going to the ASPConnections conference in Scottsdale though!
Gary
>Can I find out if the source of my recordset has any relations and what they are thur ADO?
>
>Anybody else going to the WROX ASP Conference?
>
>Jeff
"It is an important and popular fact that things are not always what they seem. For instance, on the planet Earth, man had always assumed that he was more intelligent than dolphins because he had achieved so much -- the wheel, New York, wars and so on -- whilst all the dolphins had ever done was muck about in the water having a good time. But conversely, the dolphins had always believed that they were far more intelligent than man -- for precisely the same reasons." - Douglas Adams
