reverse foreign key

[sunillarsson]

Is there a way to reverse the 'flow' of a foreign key in supabase?
For example: A director has directed many movies. Getting the directors name of each movie is the forward foreign key, but is there a way to get a list of every movie each director has directed?
Like this:

forward:

[
  { "title": "Workers Leaving The Lumière Factory In Lyon",
    "directors": {
      "id": 2,
      "last_name": "Lumière"
    }
  },
  { "title": "The Dickson Experimental Sound Film",
    "directors": {
      "id": 1,
      "last_name": "Dickson"
    }
  },
  { "title": "The Haunted Castle",
    "directors": {
      "id": 3,
      "last_name": "Méliès"
    }
  }
]

backward:

[
  { "last_name": "Lumière" ,
    "movies": {
      {"title": "Workers Leaving The Lumière Factory In `Lyon"},
      {"title": "abc"},
      {"title": "def"},
    }
  },
  { "last_name": "Dickson",
    "movies": {
     {"title":"ghi"},
     {"title":"abc"},
    }
  },
...

Is there an obvious way to this that I'm completely missing out on?

[steve-chavez]

From https://supabase.io/docs/postgrest/client/select#query-foreign-tables

forward:

const { data, error } = await supabase
  .from('movies')
  .select(`
    title,
    directors (
      id, name
    )
  `)

backward:

const { data, error } = await supabase
  .from('directors')
  .select(`
    last_name,
    movies (
      title
    )
  `)

[sunillarsson]

Thanks for clarifying that this was the case! :) I actually had an issue with a foreign key to another table. All figured out now!