Hmm, probably not on the level you guys are used to! I used the query:-
Code:
SELECT MSysRelationships.grbit, MSysRelationships.szObject, MSysRelationships.szColumn, MSysRelationships.szReferencedObject, MSysRelationships.szReferencedColumn, MSysRelationships.szRelationship
FROM MSysRelationships;
then using the link you suggested I looked at the attributes of the RelationAtributesEnum and worked out the types of relationships from the numbers under the grbit field. As I only had 5 in the end that I needed to know about I never bothered with a report and just printed out the query. Once my tables had been re-linked I re-established the relationships, and all is working well...