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.