I'm pretty sure that it will return the address for DataSet1.Tables(0). In order to get the column from the referenced table, you have to use relation.GetChidRows() to get the values from the 2nd table in the relation.


>Hya.
>
>Lets say that there are two tables in a DataSet, and both tables have a field with the same name, for instance, Address. Then I create a relation ...
>

>DataSet1.Relations.Add("Relation1", DataSet1.Tables(0).Columns("Column1"), DataSet1.Tables(1).Columns("Column1"), False)
>

>Once Relation1 is created, I need to reference that field with the same name in both tables:
>

>Relation1.Address
>

>Which Address will return ?
>
>When was it they said we were going to get VFP into .NET? :)
>Oh, sorry, it's late here, I'm already dreaming.
>
>Thanks.