[AccessD] Relationships

Hi Gustave,

Did you have a  change  to look at the  relationship pic I sent?

I cannot seem to get the collection to see these other joins.

Any  help  or insights would be  appreciated.

Thanks

Max


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: 18 February 2010 14:53
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Relationships

Hi Max

So you have compound indexes (or indices)? If not, only one field belongs to
the index that is tied to the relation.

/gustav


>>> max.wanadoo at gmail.com 18-02-2010 15:29 >>>
Can anybody help me with the following code.  It doesn't  seem to want to
give me anything other that  the  first field join.

Thanks

Max

For Each Rel In CurrentDb.Relations
   With Rel
   sql = sql & "Name: " & .Name & vbCrLf
   sql = sql & "Attributes: " & .Attributes & vbCrLf
   sql = sql & "Table: " & .Table & vbCrLf
   sql = sql & "ForeignTable: " & .ForeignTable & vbCrLf
   sql = sql & "Fields:" & vbCrLf
   For Each Fld In .Fields
     sql = sql & "Field: " & Fld.Name & vbCrLf
   Next Fld
   End With
   sql = sql & vbCrLf
Next


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com