Generate two tables

Table1                   Table1_ID          Integer
                         Table2_ID          Integer

Table2                   Table2_ID          Integer
                         Name               String(30)

Create new  application
add query1 with SQL      Select * from Table1
add query2 with SQL      Select * from Table2

add a calculated lookup field to query1 called NAME
the keyfield and lookupkeyfield is Table2_ID, lookupdatset is query2 
and lookupresultfield is Name

Add a datasouce connected to Table1
Add a grid connected to the datasource.
Set active on both queries to True.