I will cut down my real tables to these examples: I have two tables and they have a relation let me say ("ID" "Name_ID") and ("ID" "Name") I would like to display table 1 with the Name instead of Name_ID. In my case I would like to do it without a SQL join command.. I have sean something about the Datalrelation. I have filled a dataset with my two tables and created a Datarelation as described above..
Now the last step is missing... how can I display the information ? The Column "Name_ID" does not change to the Name..
Please help me with this issue.
Thanks a lot Florian