Hi all there,
I have developed an ASP script that is able to read the structure of an
Ms Access database ( via object objConn.OpenSchema(27) ) and to
identify the foreign Keys columns and tables (via
rstSchema("FK_COLUMN_NAME") and rstSchema("FK_TABLE_NAME")).
I wonder whether there is a way to read the displayed field name of the
foreign key too.
So to say, for example, in Access, I have a table books. A field of
this table is a "lookup table" type that looks into the foreign Key
FKAuthor of Authors table and displays the field AuthorName.
I wonder if there is a programmatically way in ASP to discover/know
that Authorname is the displayed field of the
rstSchema("FK_COLUMN_NAME").
I hope that this is clear enough.
Thanks.
Irena