night mare working with parent table
Ok - so i have big problem
i have 2 table in dsCompanies xml schema
1) T_ConnectionDetails (Child)
*conndetails_Code -> PK
*conndetails_conntype_Code -> FK
this table contains many connection details of company
2) T_ConnectionType (Parent)
*conntype_Code ->PK
*conntype_Name
the T_ConnectionDetails connected to dvConnDetail dataview
and from there to a grid
but
i want in the grid to display the conntype_Name the parent type of connection name and not the number - how do i do that!!!!
in generall words how do i display in a grid col from a parent (not child!) ??????? im despirate!
