3 Replies Latest reply: Apr 17, 2011 1:04 PM by Michael Solomovich RSS

    Better relationship between tables to create a tabular report


      I need to represent a report by using a table box. The data to show are linked to some tables by a referred code. These tables have a description and I want often to show the description rather than the code.

      Does exist a nice manner to create a relationship between two tables by code and showing the description in the table box?

      Fe, if I have on a db:

      Products: ProductKey, ProductDescription

      Invoices: InvoiceID, InvoiceDate, InvoiceDescription, Amount, ProductKey

      I want to show a list of invoices with ProductDescription and not ProductKey.