title: Create a field in Firebird which displays data from another table
body: <p>I didn't find a working solution for creating a "lookup column" in a Firebird database.</p>
  
  <p>Here is an example:</p>
  
  <p>Table1: Orders
  [OrderID] [CustomerID] [CustomerName]</p>
  
  <p>Table2: Customers
  [ID] [Name]</p>
  
  <p>When I run <code>SELECT * FROM ORDERS</code> I want to get OrderID, CustomerID and CustomerName....but CustomerName should automatically be computed by looking for the "CustomerID" in the "ID" column of "Customer" Table, returning the content of the "Name" column.</p>