I have managed to connect to single tables and display / edit the data. I come
from a Delphi background and was wondering if there a any 'components' that
allow you to specify the relationships between the tables / grids.

ie click on first grid1 customer no 1 then grid2 displays all his invoices etc.

Cheers