Aaron [SQL Server MVP] wrote:
> Here's a much simpler method, if you're interested.
>

"Irena" <newspost@hotmail.com> wrote in message
news:1101415978.372183.266210@z14g2000cwz.googlegroups.com...
> 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
>

"Irena" <newspost@hotmail.com> wrote in message
news:1101447517.364258.17280@f14g2000cwb.googlegroups.com...
>
> Aaron [SQL Server MVP] wrote:
> > Here's a much simpler method, if you're interested.
> >
> Where is?
>
> I visited your site but had no luck in finding an article on the
> subject.
>
> Can u specify the article?
>
> thnks.
> Irena
>

Aaron [SQL Server MVP] wrote:
> Sorry, I hit Ctrl+V but my clipboard must have been emptied
somehow...
> http://www.aspfaq.com/2520
>
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)