Relational grid data

How do I connect 2 grids through a relational field of my choice?

ie: Grid A has the following fields:

  1. grida_id
  2. invoice_id
  3. name

Grid B has:

  1. gridb_id
  2. grida_invoice_id
  3. other_field

How do I relate those 2 grids with invoice_id & grida_invoice_id?

How can I set the relationship?

Is there a sample for the feature?

Thank you

If you want to show data in the same grid - you can user render_sql on server side, and use SQL code with necessary joins between tables in it. … operations