How to build a funciton to return primary key,alternate key and foreign key fields

Hi every body. I need to create a function to return a string containing :

A) primary key fields together with primary key names .
B)alternate key fields together with correspondingly alternate key names.
c)foreign key fields together with correspondingly foreign key names.

I be happy if some one show me how to build such funciton since i never refrenced reletionship keys via vba.Thanks

Hi again,

I posted a way to do this in the response to your previous query "How to refrence acces Indexes table"... this should work, if it doesnt please let me know and I'll re-visit it... having said all that, Im still really curious as to why on god's earth anyone would want this?

Cheers...

Many thanks for your nice reply. I have purchased begining access 2000 vba book but it does not teach me how to refrence Foreign keys, Alternative keys! i do not know in which system tables these information exists and how to retrive them. As i mentioned before i need to obtain these informatin programaticaly and write them to mdb file for purpuse of creating system cataloge for access mdb . could u explain and show me how to obtain Foreign keys, Alternative keys programitaclly using vba?Thanks