Get MS Access table realtion info

[garak76]

Hi there,

in my project I read out tables of a MS ACCESS database via ADO in Visual C++ .NET.
I don’t know how I could get info about tablerelations - the information that one field is linked to another table.

e.g. I want to have the information, that the field ROOMS.ROOMTYPE is linked
to ROOMTYPES.TYPEID (with Roomtypes 1=Livingrooms, 2=Bathrooms, 3=Kitchens etc.)

Can anybody help.

Thx
Frank