How do I optimal use a relational database with a datagrid RRS feed

  • Question


    Dear experts I’m having a problem I have 3 tables in a database:

    One contains the header one the details and one contains a field with a description I need in the details.

    Most simple it can be compared with a invoice and I want to have item descriptions but from a other table.

    How can I to this the best with a datagrid (What is the best approach) a view in sql I think but I want to know for sure.



    Kind regards Peter

    Thursday, September 13, 2007 8:27 AM