Hi John.

I was able to get the column from the child in the relation because I prefix the table fields, so they never get the same name in two different tables. But when I learnt this I got curious, and will have a look at the GetChildRows()

Thanks for the help.



>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.