Hello

I have another problem now, i have a db in sqlserver, i have some tables one (let's call it table1) is related with other three, the relations are defined by the id_something, now i have to display the data from table1....

I have Something like this
Table1
Field 1 - 1 (id from Table 2)
Filed 2 - 2 (id from Table 3)
Field 3 - 1 (id from Table 4)

I want to replace the id's by some field of the related table...

How can i do this?

Btw i'm using the table adapter fill method...